Search results

Thanks for the ideas - I will try to get it updated right now and see if that fixes it. Thanks again.

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...

Ooops all of the controls are unbound

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"...

That is correct. I want the query to show only the gender that I am working with - based on the current form. When I work with the first group (males) it works fine, but when I work with the second group (females) it still only shows the males - does not change to the females. I have looked...

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...

One more question: I have the code working and it is doing everything that I want it to, except I am using that code to help me find "unmatched ID" in a query. That query uses a GenderID field that is to match the GenderID from the form. Now that I am using this code, it does not show the people...

that was helpful - didn't want to see the warning messages every time. I appreciate it alot!

That fixed it - thanks!!!!!!

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...

The reason for the double storing is twofold: 1. I wanted to use that information to create an "unassignedWorker list" 2. to try and keep from having to redo other work that was created before I started working on this project.

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...

Sorry I was not clear on the roles for each table. I hope this answers the questions. 1. the tblCampJobs lists responsibilities for the people in the cabin ie adults in charge, teens in charge, youth work assignments, etc. As far as tblCabinAssignments, that is where I was (will) compile 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...

Thank You - I will give that a try. I didn't know that existed. Thanks

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...

Thanks - I got it to work. I appreciate the insight.

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...

oops - yes I meant database - not dBase. Thanks for the insight. I will try working on this and see how well it all works.

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...