Search results for query: *

Excel has a tendency to interpret data as text which cannot be formatted. You can test by going to an adjacent cell and adding a value of zero to the cell in question. You will get a result in the new cell that is a numeric value.

We have a similar problem with loading Paradox files into Access. If any programs are open and linked to the tables in any way, we get a similar message.

If that does not work, check your ADOBE Acrobat installation(previous Tek-Tip thread saved my behind and my sanity on this one). If ADOBE Acrobat is installed with an option to load icons in MS Access on startup for Access, Access apparently interprets as a design change and locks out all...

I left out some code when I copied and pasted Dim strsql as string dim db as database set db = currentdb dim rs as recordset

I would add a few more comments. Once the program goes online, there is possibility of code and data issues. Some just give error messages, some corrupt the database and others crash the program. It is important that you create a login table or some other method that identifies users if there...

Attached code sample populates textboxes on a form without causing a conflict. Haven't tried it with a subform, but should work. 'Create a query with fields and copy the SQL code to a procedure in a module. This creates a "virtual table" that you can use as a record source for your second...

My experience has generally been identified as an MSAccess.exe error that results either from a code conflict or use of a reserved word in the wrong place.

Critical issue is avoiding conflicts in a multi-user database after splitting. I have had great difficulty finding help and would be open to any suggestions. I have just finished debugging a 50 user database on Citrix which has similar issues. My experience is... Tables in a split database...

Not sure that I follow the former Texan, being a former Texan myself, but assuming that the appended letters do not wrap to AA, BB, etc, I would convert the letters to decimals and append to get values 989.1 989.2 989.3 Then sort, adding a second field with numeric IDS, and convert the decimal...

Simple approach to tracking users or computers: 1) Create a log table with fields -- ID, user or computer name, form name, In date, Out date. 2) Assuming a switchboard, on selecting a form from switchboard, use dmax function to identify highest ID # in table, add value of one and pass value to...

You can use a 3-step process with macros or code. 1) import the new table using macros which comes thru(hopefully) with a number 1 added if there is an existing table with the same name. 2) delete the first table 3) rename the imported table. First potential problem is that if the macro...

This is code that I use on a continuous form. As the focus moves from record to record, you can copy, paste, whatever to the active record. Private sub Whatever Dim n as integer 'CountEm is function that counts displayed records on a continuous form For n = 1 To CountEm 'Cycle thru...

To ItIsHardToProgram. If you take a simple form with a table as a record source. Add the button with the code "DoCmd.GoToRecord , , acNewRec" and if there are no conflicts, it works fine. Add code such as "me.allowadditions = false" in a procedure such as form_open and you will get the same...

The code that you used should work if there are no conflicts. You will get that message, however, if you have code such as "me.allowadditions = false" in a form open function

PHV is absolutely correct. I focus too much on the SQL code for action queries.

As additional comments, the docmd.openquery works for "select" queries. You can use the RunSql code for action queries such as update, append and make table queries. I insert the debug.print function so that if the SQL string has bugs, I can go to the immediate window and copy the SQL string...

To EarthandFire. Thanks.

To CautionMP Thanks, Think I can make that work.

I have an Access 2000 list box on a form with 5 fields - 3 string and 2 numeric. Data source is a query combining 2 tables. Default alignment is left. I need to retain left alignment of the string data and right align the numbers.

Thanks PHV for the input. This has been a major headache at our end.