Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 219
Search took 0.18 seconds.
Search: Posts Made By: Trevor G
Forum: Tables 07-12-2016, 02:28 AM
Replies: 12
Views: 853
Posted By Trevor G
Re: table design

Is the database created from within 365 as a new app? if so in the design of the table create a number field, in the properties you should see in the drop down

Number Subtype: Floating-point...
Forum: General 10-27-2015, 06:05 AM
Replies: 3
Views: 2,179
Posted By Trevor G
Re: How to get system language in Access 2010 vba

Read this thread it provides the code you are asking for

http://www.access-programmers.co.uk/forums/showthread.php?t=184723
Forum: Forms 10-26-2015, 03:40 AM
Replies: 6
Views: 470
Posted By Trevor G
Re: Multiple Entries On A Same Person

I would suggest you have a One to Many relationship so when you add more to the employee record you can use the Many relationship then you can run queries, forms and reports from there for each...
Forum: Reports 10-13-2015, 08:07 AM
Replies: 20
Views: 2,380
Posted By Trevor G
Re: Export datasheet results with user defined sort order

Excellent news, well done indeed.

Thank you for the kind comments, and also thank you for the final reply and sharing the code I am sure others will be grateful.
Forum: Reports 10-06-2015, 05:01 AM
Replies: 20
Views: 2,380
Posted By Trevor G
Re: Export datasheet results with user defined sort order

What if you use the following at the beginning of the code;



This is the same as using Screen Updating in Excel.
Forum: Reports 10-03-2015, 03:21 AM
Replies: 20
Views: 2,380
Posted By Trevor G
Re: Export datasheet results with user defined sort order

Can you upload a sample of your database it will be easier to help you with a solution that will work for you. Strip away any sensitive data.
Forum: Queries 10-01-2015, 04:32 AM
Replies: 3
Views: 549
Posted By Trevor G
Re: Number of letters in a field

You can't do this with Functions in Access, you would need VBA to do this.
Forum: Reports 10-01-2015, 02:55 AM
Replies: 20
Views: 2,380
Posted By Trevor G
Re: Export datasheet results with user defined sort order

Have you tried to append the datasheet into a temp table and if that shows the data in the correct order you can then use the temp table to export.
Forum: Modules & VBA 09-29-2015, 05:26 AM
Replies: 5
Views: 851
Posted By Trevor G
Re: Command to Open Folder Using File Path Link

Welcome to the Forum,

Here is the first part of the code you need. You would have to alter the textbox name to the field name you are using on the form.
Forum: Modules & VBA 09-24-2015, 01:25 AM
Replies: 6
Views: 1,730
Posted By Trevor G
Re: Access 2010. Generate .accde using VBA code

Have a go with this code which I wrote in another thread:
Forum: Reports 08-24-2015, 03:33 AM
Replies: 6
Views: 3,001
Posted By Trevor G
Re: Printing a single record to a report

Welcome to the forum,

I am on line and noticed your thread. I have created a database that you can download to see the example. If you open the form and then select a record and use the button...
Forum: Forms 05-06-2015, 02:15 AM
Replies: 5
Views: 484
Posted By Trevor G
Re: Pop-Up Calendar

OK try this then, in Excel create a table with the Friday dates for a long period of time. Say in B1 = Type in Friday Dates, then in B2 add in the first Friday then in B3 add in the Next Friday then...
Forum: Forms 05-05-2015, 08:44 AM
Replies: 5
Views: 484
Posted By Trevor G
Re: Pop-Up Calendar

Sorry that isn't available. You can create a table and use a drop down with the Friday dates.

I would ask why though!
Forum: General 05-05-2015, 01:35 AM
Replies: 5
Views: 879
Posted By Trevor G
Re: Personalised Staff Rota

Welcome to the forum,

If you have several tables perhaps one with the list of staff so you can relate that to a drop down (which then provides an easier manageable system for updating staff),...
Forum: Modules & VBA 04-23-2015, 03:18 AM
Replies: 9
Views: 1,549
Posted By Trevor G
Re: Auto Create Emails in Outlook based on Data in Access

Look at this post it will provide a solution for you.

http://www.access-programmers.co.uk/forums/showthread.php?t=160598
Forum: Tables 04-08-2015, 06:05 AM
Replies: 7
Views: 860
Posted By Trevor G
Re: Spilt the master table into four

I would create a field giving the choices you have outlined in a dropdown then use Make Table Queries to make the new tables from this field as the criteria.

I would always as why though as you...
Forum: Reports 04-07-2015, 07:08 AM
Replies: 17
Views: 1,530
Posted By Trevor G
Re: creating a classroom schedule

Take a look at this YouTube video it will help.

https://www.youtube.com/watch?v=ZgerpTHzQes
Forum: Tables 04-07-2015, 05:14 AM
Replies: 4
Views: 873
Posted By Trevor G
Re: Importing from Excel

Are you using the Wizard to Import? Have you tried looking at a MACRO to do the import?

If you struggle perhaps zip an extract of the spreadsheet and Database so we can take a look at it for...
Forum: Forms 04-04-2015, 01:44 AM
Replies: 5
Views: 618
Posted By Trevor G
Re: dialog box for certain values entered

Ok here what to do. Open your form in design view. From the toolblx click the Check Box tool and then open the properties for the checkbox. In the properties name the checkbox chkYes and change the...
Forum: Forms 04-02-2015, 10:36 PM
Replies: 5
Views: 618
Posted By Trevor G
Re: dialog box for certain values entered

Do you mean it shows a Check Box on the form?
Forum: Macros 04-02-2015, 10:34 PM
Replies: 1
Views: 832
Posted By Trevor G
Re: Setting up Outlook Reminders

This would provide a solution for you

http://support.microsoft.com/en-us/kb/160502
Forum: Word 09-25-2014, 04:20 AM
Replies: 2
Views: 1,684
Posted By Trevor G
Re: Front page fields

You need to think about Fill In Fields and MACROS to run based on what you have selected. You would use the Fill In Fields which are found under the Developer Tab
Forum: Excel 01-15-2014, 08:39 AM
Replies: 4
Views: 865
Posted By Trevor G
Forum: Queries 08-24-2013, 11:51 PM
Replies: 11
Views: 1,296
Posted By Trevor G
Re: Query to show all books that wasn't borrowed by a reader

Eli thank you for posting the database sadly I don't understand it as it is not designed in English, I am sorry to say I wont be able to offer assistance, perhaps add to your thread or start a new...
Forum: General 08-24-2013, 04:27 AM
Replies: 1
Views: 580
Posted By Trevor G
Re: combo-box help

From the ComboBox you can add the following code to the After Update Event. Make sure you adjust the names to what you are using.
Showing results 1 to 25 of 219

 
Forum Jump



All times are GMT -8. The time now is 03:37 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World