Search results

Are you sure you are getting the same structure from a make-table? I believe that primary keys lose their "primaryness" when copied into a make table. Just a thought..

Is the primary key set to auto increment, or is it user entered? In my experience auto is much better.

Did you translate the post literally?? =[cboYourComboBoxName] If so, then you need to replace cboYourComboBoxName with the actual Name of your combo box.

Maybe try using DoEvents docmd.hourglass (0) DoEvents

Unfortunately your report will lose some of its formatting when you transfer it over to Excel. You can, however, create an Excel template and transfer data over through code. This is a very complicated process, I'm afraid. But if you are still interested tranfering over to a template you can...

Basing a form on a query will also allow you to have a Record pop up on your form that is specific to a value on your form. For example.. If you have an unbound combo box on your form that contains a list of clients, you could base the query on the value in that combo box only. This is done...

Set the data type to Currency in Table Design view. This automatically sets null Dollar amts to $0.00 (or whatever format you specify)

I had a similar problem and I found mapping out a flow chart to be the best method. Right now I've got a giant piece of construction spanning across my cubicle walls that graphically maps out exactly what the process flow looks like. The trick will be getting someone in the know to sit down and...

Create a back-end Copy before attempting any repairs. Did you try compact and repair? Did the person create a new query and then kill it? Or was it a pre-existing query? Creating query objects is not a prefered method when there are multiple users on the database. This would be the same type...

Using the Sql String Method will have no permanent effect on your actual table. I would suggest you drop your Querydef method and use the Sql method instead. Why would you edit a record when you have no intention of saving the edit? If you simply want a mirror of the recordset then use...

Search for help on the DAO.Recordset Object To create a dynamic recordset Dim rst As DAO.Recordset, strSql As String strSql = "Select tblName.fldName From tblName Where tblName.FieldName = yourParamterHere" Set rst = CurrentDb.Openrecordset(strSql) For a report you could set the...

Bummer deal.. Did the update query work?

Two part answer: 1. Why did you name your field w/ two names??? 2. Yes, use brackets (to answer your original question)

Create a string variable and put the Update query string into it. Then run the Sql using Docmd.Runsql Also, don't make things so difficult. If you simply want all of the values to change to True, then change them all to True. Dim sqlStr as String sqlStr = "UPDATE TableName SET...

No problemo friend..

Currently, you have it set up to only return the recordset from a form (not tables or queries), so why don't you just change your parameter from an object to a form data type. Instead of.. Public Function recNum(objectName As String) As Integer Try.. Public Function recNum(frm As Form) As...

Sorry about the fat fingers.. :rolleyes:

DOH!! That would probably do it too... :D I'll fix that for future viewers.

Whoops.. Put in dbOpenDynaSet instead of vbOpenDynaSet

Go to Tools->References... Make sure DAO 3.6 is checked. This allows you to use the DAO library