Search results

I relinked the files by right clicking one of the tables, selecting "Linked Table Manager", selecting all the tables and forcing it to ask for the location of the be. It says all tables were successfully relinked, but it seems none of my queries are working - although I'm not getting an error...

I did :-(

I split my database (Name1), and everything was working fine. I then saved Name1_be.accdb to Name2_be.accdb and Name1.accdb to Name2.accdb. Now my queries are not picking up any data in Name2.accdb. I have relinked the tables in Name2.accdb, but it's like the accdb is not seeing the tables in...

Thank you! 🤩

Both fields are needed, because branch no. 1 is always the Head Office for each client, who may or may not then have other branches. Changing that structure would entail major changes through the rest of the system.

Hi all :) I have a table "Branches" that has the fields "CustCode" ,"BranchNo" and "BranchName". I have another table "Jobs" where each record has a field "CustCode" and "Branch No". I am using DLookup to look up various fields in various tables in order to construct a new record in the...

Thank you so much - going to try this tomorrow when my brain isn't hurting so much!

Thank you ☺️ Going to try your suggestion on the temp query tomorrow when my brain doesn't hurt so much!

Got it!! 💃 Turns out the key violations is because the record had not yet been saved in the Jobs table, so I was trying to insert a record into the JobParts table for which there was no master record (yet).

I actually tried that last night (bear in mind I'm brand new to Access, so every solution requires another learning curve!) I was getting a nonsensical result from the debug.Print strSQL - after reading The_Doc_Man's explanation, I figured out I am debug.print'ing the SQL statement before...

(y) @The_Doc_Man Thank you for the explanation - it makes total sense :) My son actually asked me last night whether Access runs SQL directly and I looked at him blankly!

Damn! I keep doing that :-( - thanks. It still asks me for a value for intJobNo?

Thanks Doc Man.... this is a "1 step forward, 2 steps backward" problem for me, so I really appreciate your help. I have removed the parentheses. Dim StrSQL As String Dim intJobNo As Integer intJobNo = [Forms]![frmJobs]![txtJobNo] StrSQL = "INSERT INTO JobParts (JobNo, PartNo...

Thank you! No idea how I did not see that missing parenthesis. Fixed that and feeling excited, I reran it. Now I get the following error: o_O The updated code looks like this: Dim StrSQL As String Dim IntJobNo As Integer IntJobNo = [Forms]![frmJobs]![txtJobNo] StrSQL = "INSERT...

I have frmJobs with subform frmJobParts - data comes from table Jobs and JobParts. I am trying to copy multiple records in table JobParts for a previous job (the value comes from [frmJobs]![txtPrevJobNo]) and append them to the JobParts table, but with an updated job number (value comes...

I don't understand? The list boxes are on the search form. The job form needs to be requeried / loaded with the job selected on the search form?

Its too early to take all that in. Need more coffee first! blnSpace is set in the Key-Press Event of both listboxes to check if the sp[acebar has been ptressed If KeyAscii = 32 Then blnSpace = True Else blnSpace = False End If That's where I need help with the 2nd part of my question...

Me too! :ROFLMAO::coffee:

Good morning! I have a Jobs form which calls a Job Search form with a button. The job form is populated from the jobs table, with Customer name from the Customer table and Factory name from the Factory table. The Recordsource for the Jobs form is set from a query I built: SELECT Jobs.*...

Thanks @MajP - will do that!