I have a current setup where i use a form with subforms to do a similar thing. The form is bound to table 'JOBS' and when ive selected the relevant JOB i wish to look at, the subforms then populate with information relating to this JOB ie ADDRESS and CONTACT. This works because the data is in...
Thanks again! i am getting there. Ive set up the separate module so ive got pass the undefined function problem.
re passing the values to the public variables - confusion! do i do this within the form's module? the query runs and states that it is updating the field so thats all ok, but im...
Thanks again! i am getting there. Ive set up the separate module so ive got pass the undefined function problem.
re passing the values to the public variables - confusion! do i do this within the form's module? the query runs and states that it is updating the field so thats all ok, but im...
Hello again
have managed to set up the code as described by Leigh, however although everything appears to be working, the variables do not appear to be being passed to the update query.
The final set up i have is...a macro which runs a query to select the records to be updated, then adds the...
Leigh, thats fantastic, i can see the logic in this.
re no. 4 - can i force the values in even if a field of that name doesnt already exist in the table?
re no 5 - is this command button to be clicked once the user has selected the values? i intend to move the user from the form to view a report...
Hi
i need to add some additional fields to a group of records.
the group of records is produced by a parameter query, which currently ive sent to maketable as a temp store.
the next step i need to do is have the user select two more criteria - a contractor name and user id - then write this info...
skymut
as you apparently successfully imported using csvde could you help out re my post 'csvde import error' posted 12/8. we are following microsofts instructions to the letter but just getting referral errors. the implication is that an object is missing or incorrect but no clues to why...
Trying to import new contacts into AD. using csvde, error returned is
Add error on line 2:Referral The server side error is " A referral was returned from the server."An error has occurred in the program
What does this mean?
Does line 2 refer to line 2 of the csv - ie the first line of...
Hello. I am attempting to update the linked tables accessed by an front end. there are two tables -
tblHeader which has a one to many relationship with tblResult. These tables have been updated - some removes, some adds, but no change to the data structure or field type. The main form in the...
thanks all! the linked table manager did its bit perfectly :O)
i omitted to mention im using access 97 - in this the manager can be found under : Tools, Add Ins, Linked Table Manager not on Database Utilities
cheers to Hap and JFischer for your assistance
CJJC
Thanks Hap. No offence intended to consultants!! I wish i had been around when this database was built for my employer then we wouldnt be in this situation now!!
I am methodically working through checking which version of the db the linked tables go to, unfortunately we have 4 copies of the...
Hello All Helpful Access Gurus out there
I am working on a database which has a MDE built by external consultants - so of course we dont have the original mdb. I can access all the data tables and update these no problems, but I was hoping to find a way of plugging them in behind the existing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.