Search results

Also, are you placing the relationships in the backend or the fronts? Better in the front I suspect. Chris B

Memo fields are prone to corruption and of course so is Access generally. I would import the backend data into a new database and replace the current backend, also try to avoid the use of memo fields entirely. Chris B

Difficult to express what you want without seeing the code, but you can insert the current date at the time of creating the record with Date in code or = Date() in a control. Chris B

Access picks up the date format from the pc settings, so if you change the format in Regional settings, it may work out OK. I am not going to try it though, don't want to upset the pc. Otherwise maybe set it up something like =Year(Date()) & "-" & Month(Date()) & "-" & Day(Date()) which works...

Fair enough. This is actually quite messy. I have done it though by cheating a bit. Getting a set of sequential numbers is easily done in Excel, by entering the first two, selecting them and dragging down as far as you want. Takes only a moment. Now, link the spreadsheet to your database (Get...

Two reports. Set caption to suit. Always print one of the original then however many copies. Chris B

I didn't clarify this at all well, sorry. As I see it the best way would be to set up the member number table with all the numbers - 1 to 50,000 or whatever, then create a select query on the table. In the query criteria under the number field put Between [Enter the first number] And [Enter the...

The table must have a member number field. Base the report on the table and bind the textbox to it. Then it will increment as it is printed. You can edit the numbers directly in the table if you wish. Chris B

Does this only happen when you open with the switchboard, or also when you open directly in the database window? If only the switchboard, it may be corrupt. Recreate it. If also in database window, do you have an on open event? Something is wrong here. Chris B

In a word, no. Best to set it to hidden at startup. Holding Shift while opening displays it unless you untick Use Access Special Keys. Chris B

Most of this is part of the PC theme. Can be customized, but affect all programs. Chris B

If you are preparing this mess for porting to other systems, now would be a great time to "bite the bullet" and normalize the tables. How many is "too many"? Things like pasting into Excel and doing some text to columns come to mind as a first move. Excel 2007 handles 1.1 million rows. Not as...

The Migration Assistant for Access is a brilliant tool - well worth a look. http://www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en Chris B

You can provide parameters for each item in your query which can all be on your form. Shouldn't be a problem. If the category is numbers it would be something like 1 Or 3 Or 5 Chris B

Copy the database for safe keeping. Presumably it is one table which has this issue? Open it in design view. Do you see the autonumber field? Delete it. Close the table. Compact & Repair. Open the table in design view. Add an autonumber column (If it was at the top, insert row). Make it the...

If you have ghosted it and it is booting, what is the problem? If it is still logging off straight away then you need to do the steps I listed above. Chris B

<<fresh XP Install, now i copied the data (windows folder,programs files, documents & settings)>> This cannot work. You must leave the fresh install, then install your programs from the original CDs, and copy only your data. Ghost though should work. Once you ghost the 60 to the 120, if it won't...

Express is completely free but has some limitations, see this - http://msdn2.microsoft.com/en-us/library/ms345154.aspx Chris B

Month(Date()) Will return the current month. Not sure what you want. Chris B

This should be quite straight forward. Access db can grow to 2GB, so size will not be an issue. You can link to the dbase dbf database then import. Tables in backend and a front for each user should be fine. You could certainly use SQL Server 2005 Express (free) if you wish, but such a small db...