Recent content by Shaunk23

Please assist on this!!! ' Checks to ensure the related records exist for subquote If DCount("

Nope - Now getting SYNTAX in INSERT INTO ' Checks to ensure the related records exist for subquote If DCount("

Hi Michael - I tried that. You would only put that in the "SELECT" Part of the statement correct? Not the insert section?

I am encountering an error when trying to run the below... I get a "Invalid use of null" It appears if ANY of the fields are empty this wont work. This is one of a few like it that copies related records under a duplicate quote button... Is there a way in the below to allow null values and...

SOLVED - SQLDATE = "(QuoteMain.[DateOfQuote] BETWEEN #" & Format(TmpDate1, "mm/dd/yy") & "# AND #" & Format(Tmpdate2, "mm/dd/yy") & "#)"

I have the below written as a criteria.. but its not working.. I have the format wrong i suppose.. It should work for a date range. TmpDate1 = Format(Me.DateStart, "mm/dd/yy") Tmpdate2 = Format(Me.DateEnd, "mm/dd/yy") SQLDATE = "(((QuoteMain.[DateOfQuote]) BETWEEN & #" & TmpDate1 & "# & AND &...

having an issue with the below.. the debug shows fine! The fields it being put into is formatted as "mm/dd/yy" in the table & the textbox on the front end is the same... The debug shows: INSERT INTO [SubQuote] (QuoteID,TYPEOFQUOTE, Quantity, CargoType,CargoDescription,QuoteLen, QuoteWid...

Anybody have any help on this???

I have a quoting database.. alot of times we have quotes the are duplicates for same customer.. same pricing etc.. only thing changing is of course the quote number & the date created... I have Tables set up as below. QuoteMain has one to many relationship with SubQuote & QuotePricing &...

I have a profit summary im running in a report. There is a form where the user enters in 3 combo boxes the information for report IE: Job Manager, Quote Status Etc. There is then two text boxes - CQStartDate & CQEndDate In the report record source i have selected the "date created" from the...

It seemed to work the same. I havent had the issue today.. just a once or twice yesterday and other users have seen it... Everyone has a local FE (8 users) and a backend is on my exchange server. Connection created at open with a hidden login screen.. On unload it drops connection...

Hello - Just for my knowledge.. I have built a database - occastionally when opening one of the forms it will pull random record... Close it and re-open.. it works fine.. Never saves in wrong place - just sometimes will display it.. For most of my open forms i used something like...

Hello - No i need to sum the entire listbox.

I have a listbox that can have anywhere from 1 entry to probably 20 entries at a time. Its for a quoting database.. Each quote can have multiple line items.. This list shows the line items.. IE: Trucking / Ocean Freight / Customs Clearance etc.. The list has columns - ID / Description...

I am adding a section to my database.. rather then creating a separate DB. This will be used for quotations to customers... While my company does have some common customers or repeat customers we have many scattered as well.. I am trying to think about the best way to set this up.... I had...