Search results

Avoid Spaces in Table and Field Names. Amount is not a good Field Name, try InvAmount. Double Name helps avoid using a Reserved Name and allows you to identify the data easier. SaleAmount, PurAmount... Also, please set your Table and Field Names in a column eg tblFirstTableName FieldName1 -...

Also, you should Close your Recordsets when finished with them and set the to Nothing

[CODESet RST2 = CurrentDb.OpenRecordset("TblMedicareFactors_VisitI D", dbOpenDynaset) ][/CODE] You have a space in your table name. Please use code posting facility (hash symbols) Table and Field Names with spaces will not make life easier. Add Option Explicit to your Class Module heading...

Without looking at Northwind, you could add a MsgBox to the combo box asking the operator if this order is for a new client etc. If you have the MsgBox as a Response, then the vbYesNo and an if Then can force the operator to select a new client. Maybe with SetFocus to the correct combo box for...

Could you add code in the after update event of the combo box that evalutes the entry and either rejects it or clears the text box values ? Does this link assist ? http://allenbrowne.com/RecordCountError.html

Check if you have data in all the fields on the highlihted line of code. This isn't good enough for vba If IsNull([CreateDate]) Then Try If IsNull([CreatedDate]) or CreatedDate = "" Then or shorter version If CreatedDate & "" = "" Then You need to check for an Empty String as well as Null.

What version are you using ? Good idea to put this info in your Posts as the answer often depends on same. 2007 and 2010 have TempVars which earlier versions do not have. If the Global Variable is for all users to utilise, then consider a Table that can store the data - one or two records...

Not sure what your problem is about 100 sql's activated in one day ? many applications could have 1,000's in a day. If you mean some code is slow ? Review some long/slow code. Some things I notice slow code: - (Just refering to one Function/Sub) If you have a variable you need through your...

Yes, that is what I mean't by sql in code. Good news re network speed.:)

I would consider doing two things. 1. Put some code in the On Click event (or On Enter) of each Control that checks if the controls prior have been updated. This would be simple - some air code If Me.controlname & "" = "" Then MsgBox "You must enter data in what ever... first" Exit Sub End If...

Yes, Jon, I do notice pages loading faster :) Any Forums for Web Site Owners:D

Jon, You had better get your post count up :)

I was referring to vba code that Includes sql's in them. Of course, these sqls need be nowhere else but within the vba code, where infact they are just string chrs and not executable sql. If you have General purpose queries in your database, which i assume everyone has, then how you can hide...

Sorry but you are mixing words. Check your post... You really can't avoid having some queries as query objects. I say have forms and reports with their unique sql (query in sql view) pasted into their property and not as seperate queries. (some very long queries/sql's can not fit but very...

Not sure what you mean here. An SQL is a query. But.. if you want it to run inside your vba code, you need to add "" and other bits and pces so vba can use it. VBA does not recognize SQL. It can allow sql to run if it is formated as a string - don't ask why and how. All you do is make the sql to...

I don't know that having the SQL in the Form or Report will speed up or slow down the database but it certainly keeps things neat and tidy and saves file size. I understand it is the preferred method for "experienced" developers:) Ensure you Delete the query once it is saved to the Form Report...

Allways look for improvements and or faults to resolve but the sizes you have now seem quiet normal. You would be hard pressed to have a smaller Front End and the Back End will grow when data is added. A new database would have a bigger front end then back end, but not for long:D Backend -...

I assume you have a Form open and have ticked a check box or done something on the form and now want to make the change to one or more records in a table ?? If the form is Bound to a table, then most likely the form control you click on is also bound. This cahnge can be done just like that ie...

Will do but what happened between 2008 and 2012 ??

How do you jump from 1.6mb to 20mb in two posts ? or am I missing something here ??