Search results

You can add error handling to the code that opens the form. Find out the error number you are getting, and write something like this: ErrorSection: Select Case Err.Number Case = 123 resume ExitSection Case Else msgbox "your desired error message" End Select

I thought I already answered this question? http://www.access-programmers.co.uk/forums/showthread.php?t=116154

I guess what I would do is this: 1) Separate Zip Code from the city 2) Create two combo boxes, one for city and one for zip code 3) Set the second combo box (or list box, if you prefer) to only display zipcodes associated with the city in the first combo box Search for Cascading Combo Boxes...

Yes, if you are on the subform then you need to refer to it differently. See this link for the rundown: http://www.mvps.org/access/forms/frm0031.htm But the short version is: me.Parent!tabCtl = 1

Are you trying to set focus on the tab, or change tabs?? To change tabs you use: me.TabCtl = 1 Where 1 is the tab index you want to select, and TabCtl is the name of your tab control.

Also, something I've noticed is that most applications make you type the zip code, and then select a city to be used. You are having the the user type in a city, and then choose a zip. This might confuse users who are used to the more conventional method. Just a thought!

Yes, what RG said. You'll probably want to use the Windows common control dialogs to get the old and new file locations. Then, you can use the VBA command "FileCopy" to copy a file, and "Kill" to delete a file. "MkDir" will made a new directory. You can use "Dir" to check if a file or a...

Thanks for the link! Maybe I'm not thinking about this correctly, but I'm not sure how that helps. My problem is that I close access, and then call the VB Script file. The problem is that if Access is still compacting, the VB Script file won't work. The attached code will execute an external...

Hello All, I have a script that I use to copy an updated front end from a server to the user's local PC. The script runs when the old front end is opened and detects a new version on the server. The front end closes and calls the script. All works well UNLESS the front end compacts on close...

Well, you could add a date column called "Viewed" and a yes/no column called "NotSuitable." This would allow you track the date viewed if the client deemed the property suitable, or allow you to check UnSuitable if they did not.

What is the structure of your database? I guess what I would do, assuming you have a Client table and a Property table, is create a third table called ClientProperty. This table would contain the ClientID and PropertyID of any matches. When you ran the query to find matches, you could append...

Typically, you would not want to store data such as this in the database, because it can change and become outdated rather quickly. The preferred method is to simply calculate it "on demand" when you need it. However, if you still wish to store it, you'll need to use an update query. You can...

Sorry, missed the fact that it was text. Paul's got it!

rs.Open "SELECT * FROM [Interp rates] WHERE [F1]= " & ccy(x) & " ORDER BY [F4]"

I don't know of a built-in Access command, but you could write a custom function to do it for you. Asc() will give you the ASCII value of a character, which you can then determine if it is a "good" value or not and delete it if not.

Well, in order to do this you'll need to have experience with Excel Automation, manipulating recordsets, and loops. The basic idea is that you'll need to open up a recordset containing each master, or parent record. You'll need to loop through it, and for each parent record you'll need to open...

Look at post #13 in this thread. There is an example database. http://www.access-programmers.co.uk/forums/showthread.php?t=99777&highlight=combo+box+filter Just a tip - you could have saved yourself plenty of time had you tried a search before posting!

Sure, just do a search on this forum for browsing examples. They will show you how to use the windows common controls to bring up the standard windows browse menu, and return a string containing the path of the chosen file. Once you have this string, it is a simple matter to store it in your...

I think you are missing an "S": If Forms!preMeetingForm2!phaseName = "Code" then Check out this link for all about how to refer to forms and controls: http://www.mvps.org/access/forms/frm0031.htm

I'm sorry, I don't understand. You say everything worked, then you say it did not detect that you entered a wrong date.... which is it? When you stepped through the code, did your if statement evaluate to true or false? If it evaluated to False, you need to check the values in your variables...