Search results

Here's a 97 version converted from my 2000 version

Hi All, Sorry to bring this one up again, this time a have attached a sample of what I’m trying to do. It is a much stripped down version so most of it doesn’t work but ignore this, what you need to see works. I would very much appreciate if someone could have a look at this as I am stuck...

Cheers ghudson, thanks for your prompt response, the mist surrounding the VB language get a little thinner as time goes on, however, I think I still need the fog light on! Kind regards, Rach

Hi All, could someone kindly tell me how to get a folder path rather than a file path I use this to get my backend file path: Dim strConnect As String strConnect = Mid(DBEngine(0)(0).TableDefs("Blocks").Connect, Len(";DATABASE=") + 1 But would like to get only the folder path ie the same as...

Sorry for posting twice. the aliens seem to have taken over my computer, I didn't even get to finish the second time and away it went. Thanks to all, Rachael

Hi Jeremie, Thanks for your reply, I wish it were that easy!. The major problem is that each block has a compliment of chemicals applied to it. In most cases that compliment is the same so I can get a report to list the blocks on one side of the report and the chemicals on the other side by...

Hi Jeremie, Thanks for your reply, I wish it were that easy!. The major problem is that each block has a compliment of chemicals applied to it. In most cases that compliment is the same so I can get a report to list the blocks on one side of the report and the chemicals on the other side by...

Hi All, The form for this problem is much more complicated but I will try and keep it simple to explain what I want to do. I have desinged a chemical spray diary for a vineyard where the spray event is entered (single form), then linked to the event the blocks are entered (continuous form). On...

I just thought I'd resusitate this old post with my experience of error 2486. I discovered (curiously) that it only occurred using one particular backend file of the same structure as the others but different data. Anyway I got the error when opening a form from my menu. The button on the...

Thankyou Pat, I knew someone would understand the exact characteristics of Event Procedures. Its a bit hit-and-miss when you only think you know what they do. Kind regards, Rachael

Hi All, I hope I can explain this! The situation is: On a continuous form, field1, field2 and field3 - visible, for data entry On the same form 3 unbound fields that are hidden. When data is entered in each of the visible fields, after update events copy the entry into one of the unbound...

Check out the properties sheet for the form you want to turn the X off, look through the list of properties and you'll see the option (sorry I can't be more specific, I'm sitting at a computer that doesn't have access on it), I think its 'Close' or 'Close enabled', its near the option for the...

Is anyone able to divulge any small bits of info on this subject? I don't care how small! Thanks in advance, Rachael

Hi, I was wondering if someone could enlighten my small brain on Jet engines? I understand that 2000 and Xp use jet 4.0 so when an application is distributed with runtime all is OK. Lately I've been having a few dramas with Access XP. I develop in 2000 and distribute with runtime (if its...

Thanks ghudson, I've learn't a lesson thats for sure, thanks for the info on Windows XP. What I have decided to do is create an area for the user to enter in the path of where they want to have a copy of there backends made to and store this with there data. I have incorporated a tick box to...

Geez Thanks Namliam for the quick response, over here in Australia I'm used to posting one day and getting a response the next. thankyou also for the clues, I was assuming that C:\My Documents was a standard thing on all computers and would never pose a problem. Cheers, Rachael

This might be stating the obvious but wouldn't you need to have the CD writer program launch, you can't just copy files to CD's like you can with floppies, unless there has been advances that I'm yet to know about with the new windows version (I'm still using 98) Rachael

Thanks Namliam for your response and testing, That has narrowed down the problem, does the My Documents folder exist with Windows XP? Perhaps thats my problem, becuase the other day I had a client running Office 2000 have the problem occur, perhaps they are running Windows XP. Could I possibly...

Sorry, I should have posted this in modules vba, please forgive me....

Hi, I have posted thisissue a few times over the past week but will little success, so sorry to be repetitious. The problem; I've got these lines in a A2000 db that I use to get the backend path so that a copy of the backend can be made each time the user logs on. The event is in the on-open...