MessageHello John, This works great, except I had to add Me.DeptSpecFrms.Undo within the IF. Should I need to do that with the Cancel = True? May our Lords...
You can add the Undo, but I like to let the user see what they typed, so I don't use it. If DeptSpecFrms < 1 Or DeptSpecFrms > 4 Then MsgBox "Not Allowed." '...
Funny you should ask this question, Doug. I just posted the answer on another board. What we have here is an example of the difference between the .Value and...
To navigate through the recordset I'm doing this: Private Sub btnEmpNext_Click() If rs.EOF Then MsgBox "No more Records." Else rs.MoveNext If Not rs.EOF Then ...
Hello- This is the first post I've done. Am hopeful (desparate) for some help. I created an application in 2000 that works beautifully- on my computer (Windows...
I can't test it right now, but try it this way: Private Sub btnEmpNext_Click() If rs.EOF Then MsgBox "No more Records." Else rs.MoveNext If Not rs.EOF Then ...
Welcome, Lance. Hope we can help. Nothing worse than finally getting a contract after a dry spell and then having your app blow up. I was under the impression...
wow. that was fast. great thought on checking that they have all components installed. will definitely check that out. and can try converting to XP to see...
Thank you Bill, that helped. The msgbox pops up without the second click. The previous or next button still take 2 clicks to move the data even after changing...
Hi, I have a subform that has multiple records (of the same table). I also have a button on the footer that calls a report passing the key from the current...
Done it again !! Save the current_record number (Curr_Rec = Me.CurrentRecord) then after the requery For i = 1 to Curr_Rec Me.Recordset.MoveNext Next i Richard...
I have a set of Access 2K databases that I use as a frontend and backend for my vehicle maintenance shop. A portion of this database system tracks vehicle...
You wrote: Microsoft ActiveX Data Objects 2.5 Library reference kept directing to a MSADO25.TLB file That's the right file. It's a Type Library. Dim cat As New...
John If you use the DoCmd.SendObject command instead of the hyperlink you can modify the subject line by concatenating the field to the Subject string. In...
I'm a self taught Access developer, and have come to need some help from the pros. Within one of my forms, I have a few fields that I would like to have...
One thing I'd like to mention.Use the AfterUpdate event of the combo box to run your code to enable the controls. This event fires as soon as the user picks...
Hello Bill, Lance, I had similar problems when I installed an application developed by Acccess XP on Access 2000, it gave me error messages regarding ...
Yes, I am also referencing the Microsoft ADO Ext. 2.5 for DLL and Security and that is for the ADOX.Catalog. Sorry to confuse the issue. Although I will admit...
Hello friends, is it possible to write stored proceduers (like pl/sql in oracle) in access ? and i want to call that procedures from my vc++ program.how to do...
suresh babu k
ksbabu@...
Feb 4, 2003 4:16 am
3060
Yes you can write stored procedures, I know that for certain. I don't know how to call the procedures from outside of Access but a standard ADO connection...
Ey? You don't mean store them in Access do you Chris? You can 'write' a stored procedure in an ADP which is actually storing it in SQL Server as per usual,...
Im afraid this is slighly off topic hope you dont mind. I have been having reliability problems with a frontend backend system in access 97 so to get a more...
Sure, a couple of ways.. You can detach the database from server1, and copy the .mdf and .ldf files. Then re-attach the database on Server2. You could also you...
When I open a split database, I'm usually looking at the front end, complete with queries, forms, reports and so on. I can open any table and add, edit or...
Ive tried that and after starting sql on server 2 it doesnt recognise the new data base !!!! ... and .ldf files. ... from Server1 ... data. ... an ... but ... ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
