Search results

File-->Get External Data--> Import and then choose the old database.

Look at the menu bar on top. Choose Tools--Database Utilities--Compact Igor.

Your procedure or query involved is too complex or wrong. I had the same problem few times.

1)Delete all records from the table 2) Compact your database. That is all!!

Take a look at the shared .ldb file which could be at the same location as your database. If you do have it then physically delete it.

Create a function which will read a query. In your query just select last record(Item #) using function "Last" or "DLast". You gonna get the last record, then +1. In your macro you can easy attach this function. Igor.

You can use DAO method to talk to database which you link tables from, manipulate with a table structure(alter table). After you added field use "TransferDatabase" method to relink tables automatically.

Why don't you convert MS Access database to SQL Server 7.0/2000 which allows you to keep a huge amont of data as a backend and MS Access or Visual Basic as a frontend?

Try first to create a new database. Then File->Get External Data->Import. Import all what you have (forms,macros,quiries,reports,modules) to a new db. It could help.

Then do the same manipulation just for the "case#" filed.

= "Title" & Chr(13) & Chr(10) & Date() sometimes does not work if database is located in SHARE DIRECTORY in Network..., but vbCrlf - always!!!

I would correct a little syntax as: "your candidate" & " " & [member name] & " " & "has been found worthy to bo initiated into our illustrious order."

Try to use function IIF. See examples in Help file.

Create report and group by offense code. So your field "offense code" will have offense code header. Then manually create on report offense code footer . Place in footer "Page Break" control from toolbox.

To Fornatian: Report wizard cannot give you merge info from 2 tables. You need to use Query wizard first: add 2 tables, joint them by related filed and save your Query. Then use Report wizard and select the saved query as recordsource of report. Igor. With love form Russia.

That form will be opened along with opened report and filter your report recordsource based on modal form's criteria.

I disagree with Travis. 1) We are talking about combobox selection, not a textbox. 2) We are trying use either "All" or real value as one source for combobox!!! Solution: 1) Query for Combobox which murge values and "All" Select field from TableName UNION Select "All" from TableName 2) Depend...

I agree that DLookUp is much slower than to place combobox with recordsource. To refresh your form with lookup filed: YourField.Requery Me.Refresh Text1=Null 'clear info Text2=Null 'clear info etc. If you really want to go back(previous info) then why don't you insert this info like "Insert...

Hello You need to built combobox control which based on a query contains all fields you interesting in. Use After_Update() event to assign field values to other textbox bounded to your table fields. Use method Column(0), Column(1) etc. belongs to your combobox for this purpose. Igor.

Hello, I am sure input mask will be like: >LL0& 0LL , but >LL09 0LL is wrong - 9 still required a number. Sincerely Igor.