Search results

That is the weirdest. I did the above, it worked but then I took out the msgbox (the only difference between mine and yours) and it worked. I do not understand. But thanks

Why? Like I said, I'm confused.

I'm confused. This code works from a button on a form Private Sub Command0_Click() Dim intBoatNumber As Integer intBoatNumber = Nz(DLookup("intGlobalOptionsId", "tblBoat", "accStatus = 'On'")) DoCmd.OpenForm "Global", acNormal, , "Forms![Global].[intGlobalId]=" &...

I am really not very good at the math but your initial working of percentage seems to work to a suitable level for my needs. Thanks for your reply. TBH I don't think I'll need the other formula but thanks for your generosity. :)

DFenton, I am implimenting the Levenschtien function in my database to good effect. What I would like to know is something that is possible so simple that I am blind to it. In the function it returns LD as the number of iterations needed to change from string1 (source) into the string2...

No I don't beleive we have both A97 and A2003 on the same machine. I know for a fact that it is all to do with updates to user profiles. Whenever this happens, if I follow the procedure above i.e. open access program first, a box stating that the system is updating profile appears. After that...

Hi, I have searched for unrecognized format in these forums and can't really find the definitive answer to my problem. I have a database on my work system which runs fine. Whenever the system makes an update to Access 2003, however small the update is, when I attempt to open the database it...

Freshman, Bob, I have changed my code and taken out the $ and it works perfectly. Thanks

Freshman, that's exactly what I want it to do. Perfect. Thanks

As the title may suggest, I am not looking for friendly advice about going to the cinema, rather a geeky problem with my VBA code. (Maybe I do need the former lol) Anyway, I have a textbox which holds a date/time using the following format: Format$(Forms![FRMSIGNAL]![txtDTG], "ddhhnnZ MMM yy")...

Solved: Been playing around with this for, well the best part of 2 days now and I finally cracked it. For anyone who'd be interested, I just had two queries, the first looked at records with both 1's and 2's and the second looked at just records that contained the 1's. It is a little bit...

I have this working manually where the user is prompted if he/she selects too many items but are there any brains out there who can solve this automatically. What I would like for it to acheive is this: Say the listbox contained four number 2's and twelve number 1's making a total of 20 I...

Thanks P :) Works a treat. Only thing different was the column number and the type. :)

Hi, The title doesn't really make up the question as there is a fair bit more to it but, here goes. I have a listbox on a form which is populated by a query on a table with 6 columns. One of the columns intTextLength is an integer containing the number 1 or 2. I wish for the user to only...

Just wondering how long it will be before the company updates to access 2007 and whether it's worth implimenting this code. Anyway, thanks for the help. BTW I checked out the link you sent me, some very interesting ideas. :)

Ahhh ok. So it will work as expected on my works PC which is 2003?

I have this file already and when opened the reference for the common dialog produces an error. I am working on a 2007 version at home but the DB is to be implemented on a 2003 system.

It will be running on 2003

Hi, I am using this: http://www.everythingaccess.com/tutorials.asp?ID=List-files-recursively to show files in a listbox. Just as one of the replies asks, I too would like to know how to allow users to open the selected file. Thanks

Having the email visible prior to hitting send is not a problem, in fact I have it set that way at the moment for testing purposes and I am of the opinion that, if I were the user it would give me a warm feeling that I was acheiving something if I could actually see the message. This is clearly...