Search results

I've got something that works somewhat but I know there must be a better way. I have been through hundreds of posts on AddNew and ADO and SQL Insert and can find nothing about inserting/creating multiple records into fields in a junction table and then tying that to my main table. I used this...

You're right, that IS complicated. But, if I use a subform, how do I get a column for each job role since the job roles are just records in my jobs table? It's just ging to shows up in the subform with the column jobrole and then 6 records? Or, are you saying that I can only have one combo on...

Unfortunately,the layout requirement of the form won't allow me to use a subform so I will try the ADO/DAO code. I am struggling with this however. If my tblStaffJunction only has fields staffid and jobroleid and my 6 fields are named projectname,pce_eng, ffpbuyer,ccmbuyer, etc., how do I set...

Can't seem to get my form to update my tables. Would appreciate someone giving me some suggestions on how to make this work. I have tblProjects and tblStaffJunction (which contains AutoNumber id fields and the PK from tblProjects,tblStaff and tblJobs). I created a query from tblProjects and...

Thanks Pat, I think I have it. I have tblStaff and tblJobRole, created a junction table with the projectid, staffid and jobroleid and can tie this to my main project table with the project id and eliminate the 6 fields in my project table. Sound right? Toni

I'm am stumped as to how to do this. I have a table "tblStaff" and a table "tblProjects". My form is bound to tblProjects and contains 6 cbos all bound to tblStaff which represent different job roles on the project. The "staffid" is what I am storing in tblProjects for each of the six...

I have a form with the following unbound fields: Side A 15 cbos with the same Row Source (connector1, connector2) Side B 15 cbos with the same Row Source (same as Side A) Vendors 6 cbos with the same Row Source (vendor1, vendor2) Wire 3 groups of 3 fields - same Row Source cboStyle...

I'm wondering if it is possible to use a Select Case statement with command buttons. I have 5 command buttons to group supplier choices alphabetically (A-F, G-L, etc.) On_Click is set up to open a form filtered with a macro to show only those Suppliers in that alpha group. I'm thinking a...

Thanks for the sample-I'll give it a try! Toni

Thanks for the response Michael. I'm getting a "Datatype mismatch" error with this. Any idea why that would happen? My combo box is "text" and my picture field is a Bound Object Frame. I loaded the images in the Connectors table by right clicking and inserting. It shows up in the table...

I've looked through all the code I could find in here but can't find one that works for my situation. I have a form with 15 unbound combo boxes all filled with the same data (connector names). The user will be able to select up to 15 connectors. I would like, when a connector is selected, to...

I would appreciate anyone who would look at my form and tell me why I am getting this message when I select an item from my third combo box. I got the code from Candace Tripp's site (thanks Candace!)and it's works perfectly on the demo but I can't seem to figure out my error. "Run-time error...

Thanks Wayne, It did let me import the objects into a new db, but the references were still grayed out-don't remember, but it must be that I wasn't viewing them in design view. Anyway, for some reason, the db started working again last night. It's on a network so perhaps something was wrong...

Two days before my vacation and my db has died (Access 2000 with WinXP Pro). I have it split and residing on a shared drive. When I open it I get the "db is read-only" message, I click OK and I get "Runtime error 2105 You can't go to the specified record", click Debug and it takes me to my...

Got this fixed, I think. I went ahead and created another .mdw (NEW.MDW) and linked to it and everything opened fine. Apparently somehow SYSTEM.MDW did get modified-which ticks me off because I followed the user level security instructions to the letter. I installed a copy of SYSTEM.MDW from...

I followed all of the steps for User Level Security, wrote down logins, pw's, PID's, etc. created a new .mdw, rejoined system.mdw, created a shortcut with the target to msaccess.exe, new .mdw and db. It now prompts me for a password for all db's, including trying to create a new one, but does...

Is the form bound to the query?

Here is just one of many sites you can find on the net that shows ASP. http://www.asp101.com/samples/index.asp Also, I recommend the ASP Databases by WROX publishing. Good luck to you, Toni

Got another one along the same lines and would appreciate a point in the right direction. I need to now take the amount in 1 column [Reduction in Cost] for all records and, based on the [CutInMonthNumber] disperse that amount through each month and add up the totals for each month. I want to...

RichO, This worked perfectly! Thanks so much for getting me through this one!