Search results

I have a form with a simple combox box on it. The database is split and is used on several machines. All the machines axcept one has the combox working fine. The one machine does not show any of the combox information. It does, however show the information for the other two comobo boxes on the...

Hello: I have a form that uses several unbound combo boxes to add information into existing fields and tables (using coding). I set the form up so that I can keep track of the number of items entered per group. Once I am done enetering information for that group - I want to "clear the form"...

I have a combo box in a form based off of a query - qryUnassignedCampers This query is an unmatched query to help me find unassigned participants in a program. I use the following code on my combo box SELECT qryUnassignedCampers.CamperID, [CamperLast] & ", " & [CamperFirst] AS Camper...

I am working on a form and am getting the following error. Syntax error (missing operator) in query expression '55WHERE tblWorker.WorkerID=20090007' Here is the code that I have taken and reworked based on information from the forum. sSql = "UPDATE tblWorker " & _ "SET...

G'Day: I have a form based on a table - tblAssignments WorkerID JobID LocationID from that form, there are combo boxes that allow me to select a person and then select their job. What I need is after that person has been selected, I need to update another table - tblWorker to include the...

I have been toying with this for some time. First - I am fairly new to Access so all information shared will be greatly appreciated! I have: tblCamper AutoNo - PK CamperID - Generated ID - Linked Camper Name etc tblCampJobs JobAuto - PK Job ID Job tblCabin CabinID - PK CabinName...

I am sure there is something on this site concerning this issue, but I am fairly new to Access and am not sure what to look for. I have a daabase that has: tblStaff ..AutoID (Primary) ..StaffID .. etc tblAssignments ..AutoID (Primary) ..LocationID ..JobID ..StaffID (linked back to tblStaff...

I have a subform frmIncomSub that has five fields on it based on a qry Fields are: Identifier Fundraiser Date Reimbursement AmountRaised AmountAvailable (caluculated Reimbursement * AmountRaised) Identifier is used to link the Main Form and the subform. The query is based off of the...

G'Day: I am working on a dBase that will allow me to track multiple users and allow me to place them in categories based upon work sites. The users can select the people that they want to be with at these sites (essentially their team). What would be the best way to set up and eneter this...