Search results

I found that out on the net or a bookand it said for access 2002 to use that DoCmd.GoToRecord , , A_NEWREC ...I did originlly have DoCmd.GoToRecord, , acNewRec 'Insert a new record I still get the same error..please don't give up on me...help some more

I am using Access 2002 w/ win XP..I have a table called Calls..I Have it set to no locks...I have an add button with the following code. Please do not recommend using autonumber not an option at this time. I have multiusers all accessing the form. It is split database on a file server. If...

can't anyone help me with my previious post pattyt 04/09/03..got no responses...really need the help...code was attached for review...thanks again

To add a record I use the following code which will go into a table "invnext" which has one field "helpno" .I increment this number by 1 and use that as my new helpno however I keep losing numbers. Does anybody find anything wrong with my code. I am on a file server with multiusers on the...

I have a form which brings up a list box of all my reports. This formOne has a button to preview the report with the code DoCmd.OpenReport Me!lstReports.Value, acPreview It works great, however some of my reports have a user input box form that popups for the criteria. This popup form has a...

I have made 3 queries..the first one makes a table (HLPFILENEW) from an existing table (HLPFILE) where certain values are null...the 2nd query append records from the same existing table (HLPFILE) to my new made table (HLPFILENEW) with different criteria...the 3 query selects records from my...

Please help! I have 4 dates on my form named hlpdate, hlptime, fixdate, fixtime. I need to make sure my fixdate and fixtime are later than my hlpdate and hptime. I have code on the after update for my fixdate field something like this... Private Sub FIXDATE_AfterUpdate() If FIXDATE < HLPDATE...

I've chk'd previous topics like mine and am still stuck...want to use code and not action queries..the two forms open w/matching helpnos...need the sql to find and only do the updates to that matching helpno..may involve the where clause..I made an update qry and viewed the sql, it uses inner...

I have two forms, one is main callsMFrm the 2nd form is callsTFrm. I open the main form and enter alot of info (place, tags, serials, fixedate, fixtime,solution ect) then click a button to open the callsTFrm form which pops up with the same HELPNO as my main form. Both forms show on the screen...

is there a combination of keys or something if you are working on a form and want to fill in the fields with the previous records fields?

Still need help with coding..my main form "Help Calls" will stay open in the background with all the pertinent info the tech will need to finish the call...my main form takes up all the screen and I have no run for a subform...will need to pop up a small form with just the few fields needed to...

I have a form called "HelpCalls" which already has numerous fields..it has the following "fixby", "fixdate", "fixtime", "problem" & "resolution" fields plus many more ..however one tech may work on the call, do his part and time & his resolution and it needs to be reassigned to someone else..I...

I have a field called helpno on a subform that I want to double-click on and it opens another form..I used a Macro that works fine..however I want the form that I am opening to open on the helpno record that matches from my subform...I tried using where condition on my Macro and messed up...