Search results

That sounds like the bit i am struggling on, so would i start with If NewRecord Then If Not IsNull(Me.OpenArgs) Then strOpenArgs = Split(Me.OpenArgs, ";") Me.TbJobId = strOpenArgs(0) '.. If there were more arguments ' Me.txtAnotherTextBox = strOpenArgs(1) Else...

the issue is not so much in adding a record, if you delete all the data in the tblmeasures table, and then go on to FrmInspection, it creates a new record - i think this is due to the primary key, and the job number being stored. How do i deal with these false records ?

updated - removed the code form the combo boxes

Latest version - OpenArgs working, but creating blank record, just storing the Job number - am i doing something wrong or do i need to build in to delete the blank records ?

Ok, i have managed to get the OpenArgs data to pass to the 2nd form using the code posted by Badly Bob in another post. I still have a issue that it creates a new record with just the job number stored in the table.

Imported into New DB and now only 1.5mb

how can i do this if it is not actually a subform, but a separate form..?

that's what i dont understand, i have 3 tables with 3 records , and 3 forms, and i cant make it any smaller. With the Ref to OpenArgs, i think i have done it right, but i think the issue is more around that i have the code on the on enter field, I have tried on before update, but one of my...

Hi all, i need some help, Firstly - i tried to zip a copy of my database so i can upload, but the smallest i can get this is 12mb, so unfortunately i am unable to upload. I have 2 forms - FrmMain and Frminspection. My main form (FrmMain) assigns a job number to the request, and then when...

I have set up a new form with a Tab Control, that contains 5 tabs. On most of my forms in my database use the below code to track changes to fields that are Tagged ? If I Tag the Tab Control, I get error 2427 - You entered a expression that has no value. or error 438 - Object does not support...

Managed to get it working, in the end. Thanks.

after thinking about it, i dont think that would work as i am going to run this on about 20 reports,

I am playing with some new code below to log the time that it takes to run a query. So i have added a new function called Startlog and EndLog. I want these to use the function name as i log this in my table, is there a easy way to pass the Function name to StartLog and EndLog so i dont have...

I wish I knew why it takes so long. I have some data in amazon AWS / sqlserver that I use to look up against, and my main data is kept in a back end with aws. I have 15 reports that export every morning, some days to export all 15 reports takes approx 6 minutes, other days same reports can...

I have the code below to import tables from my Master database to my Dummy database. The problem i have is the the Master database table is a link to a SQL table, and i want it to convert to a local table (Taking too long to pull data from SQL Server), and not just copy the link. Is there are...

Just found the issue - someone had unticked the Live Field... Thanks all.

Still Struggling with another Dlookup for multiple criteria. My current code which works is WhoCharge = Nz(DLookup("Processor", "TblQCPreRetailSuppliers", "Supp_Code='" & Nz(tbSup_Code.Value, "") & "'"), "") and i want to add another criteria to check if the supplier is live, so tried this...

Thanks, interesting read, the issue only started showing a couple of weeks ago, so i was thinking it might be down to a recent update. I will try some of the solutions listed.

Hi all, i have been having a few inconsistent file issues on my Front End recently. I have checked all my tables, and they do not seem to be corrupt, All forms and queries work, but i am seeing this error on a daily basis. Do i need to create a new Front End - Copy all current Forms / Queries...

I Understand - i might try to strip it back to basics and then post