Search results

I have a table with the followig fields where I do all the work on imported data. I then need the data to be sent to their permanent tables. Some of the below data is repeated in that there are many of the same sample no and client id to the different results. The permanent tables solve this...

I have a temp table where I import information and do work on it. I want to transfer the information to the permanent tables upon completion. Here is the problem: the temp table contains multiple instances of the same information in the first half of the fields and new info in the other half...

just a note, this is the answer: If InStr(1, rec("ClientID"), vtemp) > 0 Then

In the first form in the included db there is a button called command30. This is where I am testing my code. I tried using 'If .. Like .. Then' inside a loop and it worked once ( :eek: ) but it doesn't. I am wondering how I can accomplish this? I got the compare to work, check out...

can you help a little more with that?

I am looking to make a function where you hand it 2 strings (single words) and return a string. The strings are to be compared in that the first is the string to test and second is to compare to. What it needs to do is take the RIGHT 2 characters from the first string and compare it to the...

I have a db where I am trying to automate the import process so that the user only has to press the button basically. I am having trouble with a part whereby I am trying to find a pattern in one table based on entries in another (maintanence table). The form I am searching is...

Here is an updated version ( and working relatively well ) of what I wanted to do. I am now looking for suggestions and help on improving the form command30 button. I think that the barrage of popups if the same entry occurs more than once is a problem. Is there a way to update ALL the...

I Really would like to be able to do all of this in the recordset PS thankyou very much, for some reason the whole open the form and return a value thing works now. I open it and when the user chooses OK then i set it to invisible, set the active form hidden_temp to the popups value then close...

Can you help me do this in all recordset? It would cut down on code and probably make things a LOT easier ... Also, the MAIN intent of setting the flags is so that the user can input a different value from a dropdown. Is there a way to open frmrecedit and wait for a return of a value from...

yeah, pop up, modal docmd.maximmize is how that is done... also turn off the control buttons and make the border = none

I am having the stupidest time with a form... I have the form to import data from a file. the code in the command30 button is what is giving me the trouble though. I am going to have it run automatically after the import. The problem is that If the loop encounters a value not in the...

Why won' t this accept the ' _' as the carry to next line in: DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO tblWater_Sample_Temp ( ClientID, ProjectNo, LabID, _ Matrix, DuplicateOf, SampleDate, Analyte, Method, Result, Units, LOQ, Outlet_ID, _ Elevation, Unit_ID, DataSource...

I am trying to Edit a recordset on the fly using the following code. The problem is in the BOLD text in the code. It is supposed to set a Y/N field to true or yes (whatever) But it doesn't. Can SOMEONE please HELP! ~ :confused: 'ONLY 'ONLY do the following if there are records to work on...

Ok, I know I have posted about this before, but I really have to resolve this. I have a form where by I am doing checks on data to see if the imported values are existing in a maintanence table. So after all the data is imported I am cycling through each record checking if the entered value...

I have this already... BUT it doesn't stop and wait... It either stops or finishes the work without waiting... That is why i make frmB invisible, pass the parameter, then close frmB... I am including the db, try running the form import and you'll get a better understanding of what i mean...

The problem is in the ELSE statement AND the fact that it doesn't wait for a return form the other form! There MUST be a way to do this. BUT I AM STUMPED! i really need help...

if you open the db and try that you'll see my problem.

can you shed some light as to the example given in the first post (the included db?)

Can you put a dropdown in a msgbox? i have the following: I want the user to be able to select a value from a table when they Select NO to entering a new value. the code is run off the commmand30 button at the top. Currently it pops up a form with the msgbox, but it fails to wait for a...