Search results

Echo off will turn off screen updating in access. It can be useful if you are running macro/vba code which has visible effects on the screen. But you need to remember to turn echo back on at the end of the command. I have really only used in excel vba though. If selecting a field stops the...

I would use an if statement on the combo box after update event. I prefer to do it in vba but you could use the expression builder.

How do you have the calculated fields set to run? Do they update as you type or are they run when you exit a particular field? If you have a lot of calculated fields which are set to update as you type (real time) that could explain the flickering and crashes. They should be set to run after you...

This will require a bit more of an explanation. Start with table and form structure and what are your calculated fields for? Do the results need to be stored or are they just for viewing at the time? Post a copy of your DB if possible (zipped)

Take a look at this is should help you. http://youtu.be/d2PI6w_J95Y you can use the dlookup for the family and Dmax +1 for your increment, this should probably be done with an auto number though.

I have recently faced a similar problem when migrating from 97 to 2010, None of my VBA code worked. I managed to fix this by using compile the project in the debug tab of VBA. Might be worth a try

I have been using =Environ("username") for this.

There may be easier ways to do this but one way is to create an append query. Create an append query which will add the data to another table, using the ID field as search criteria (do not append the ID number leave the 'append to' field blank). Once this is done add a button to your form and...

Not sure if this will help I get the current user name using Environ("username") I use this with a basic If statement to limit access to certain features or buttons

Check in your XLSTART folder, Should be in c:\program files\microsoft office\office15\XLSTART (the number after office above will depend on your version) Anything in your XLSTART folder will open automatically on Excel launch Hope this helps

Hi, welcome to the forums It sounds like you are only using the tables within access I have uploaded a very basic DB with a navigation form and input form for the tables. The wizards will guide you through most things like creating an input form. To create a navigation form you simply create a...

Do you need to use Word? If all you want to do is represent the data in the subform you can use the report function in access. This will also allow you to simply drop your form directly into the report.

I would rather get it from on here. The site is very easy to upload to

It sounds like you need to set the relationships between the tables. Can I suggest that you have a look at Microsoft learning centre it will show you most of the basic features for your version of access. If your still stuck then post your DB file and we'll have a look

I have a database which is split into FE & BE, the BE is locked open by a forms server. I have a way to force a close but have to contact someone to reopen it. I would like to be able to code a compact and repair to run during the night ideally without having to close access. Access 2000 by...

I use a macro condition to ask the use if the user has loaded headed paper. this bit goes in the condition box of the top action and any other actions below that should be condition ... Msgbox('Haeded paper loaded?',1)=1 ... ... hope this helps

Personally to run code like that I would use a splash screen on open and run the code on form_load. You will still need to find a way to identify which users have which access level though.

I have found the best way is to change the start up options to open a form (Welcome Screen) and run an OnTimer event to open your main menu and close the welcome screen. I had to play with the time setting to get the time right though. Try searching help for "OnTimer" for more info

I have recently upgraded from 2003 - 2007, if you google 'access 2003 ribbon' there are many sites that you can download add-ons which add the old menu's as a ribbon. I have been learning that way and if I get stuck then I can use the old set. Only problem is I can't use all of the new features...

having just upgraded to 2007 myself check your access settings there is a tab to select how you want to open the file i.e. 'open exclusive' this could be part of the problem