Search results

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...

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...

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...

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...

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...

I have a main database for an office of 10 people.. We have a separate one for quotes.. I have been thinking about combining the quotes into the main database so the users have just one open to work in.. the back end is on my exchange server.. What would be the more sensible or efficient way...

All users in my office have dual monitors.. Ideally id like to - Find out which monitor the user has the database open on - ensure popups open on that same monitor. Right now occasionally some of the forms - password ones & print dialogs will open on 1st monitor IF the user has the database...

I have queries that are done by date range.. Below is my case statement to set the criteria... I need it to be checking for the current 30 days, current 90 , current 6 months & year. The problem im getting is it shows all the shipments when i select "30 days" all shipments are greater then...

I have deposit tickets that are formatted like this.. 060112-1 and will increase the last digit as tickets are entered for that day... So if there were 11 tickets on 6/1/12 they would be listed as below.. 060112-1 060112-2 060112-3 060112-4 060112-5 060112-6 060112-7 060112-8 060112-9...

I have a tracking form that has up to 15 events.. each event has description / date & confirmed(combo box). Combo box are set as value list - yes/no. No =false the event hasnt happened & yes it has.. When the user is entering information and tabs through the event & date and into the...

I have an SQL statement on a listbox which displays cash receipt tickets. In the event the user enters a date range where there are no records i get the Invalid use of null error.. How can i force it to either display nothing or a msgbox saying there is no records. Here is my statement.. SQL...

I have a table & shipment segment that is labeled shipment log.. the user can enter logs as he works through a specific shipment. In another part of the database the user can print or email arrival notices or other reports.. When the user emails or prints this form i would like the shipment...

Hello - Im wondering for general practice what i should do to increase performance. I will have 8 users using my database which i have split.. Has over 30 tables on the back end placed on our exchange server. All users have Front End apps on their local C drive. Performance is pretty good -...

I have outlook module that sends out forms... I have many different forms in the database.. in order to do what i needed i Save the Report as a PDF on my server, then delete file once attached to my email.. That being said as you see below i had to hard code the "save path" name in.. Is there...

I have about completed my first large database.. I will be making it live on a server front end / backend soon. Since my knowledge is limited & im learning as i go i would like some input on the restriction of things... I notice when i print preview a report i have to right click to close.. in...

In my database i have many fields where i need the user to be able to copy the text to clipboard to cut down on human error... Literally there is probably 50-60 of these fields. Currently i have them setup like this on the double click event.. If IsNull(Me.Shipper_Full_Address) = True Then...

I have a main table.. the main table has fields for TotalGross / TotalCube / TotalNet etc.. Another table linked ( 1-many) hold the actual cargo.. (crates etc..) A listbox on the main shipment page holds the values in columns (seal number / Gross / Net / Tare / Cube. This all works...