Search results

I have created a parameter query and then a report from it. The query runs without any problems at all, but when the report is run the same parameter request (from / to dates) repeats 3 times. I cannot find any reason why. If I enter the same date range 3 times it works fine. Any help please...

I have re-posted this as I could not see it in the General Forum. Mde I am often getting corrupted front end database, the tables are not effected or at least recovered without problem via the compact and repair facility. If I force my users to use the MDE version of the DB can this be...

How can I default the print layout from a query result? I can set and save page layout and margins but when the query is re-run the defaults have reverted to the default printer settings.

I think I may have found my problem, the main form I open has a lot of fields from one table and a couple of releated feilds from another. Each field is specified with a select statement and then a join for the other table and select again for each field. I think it is this that slows down the...

I have now finished my database and have split the tables etc, converted the front to an MDE file. When connected everything is fine for all the users. My question is about the logging on time it take to connect to the backend. It seems to take ages but in reality probabaly about a minute. The...

The data base is not split, I have an intention to do so once I am satisifed with its overall performance. I have compacted it today but not on closing. Any suggestions as to when this should be done? Would it be better to split now?

What would cause my database to keep coming up with the "needs repairing warning when trying to load. This has happend 4 times today and I have been able to recover from the self repair 3 times, luckly I had a very recent backup on the 4th occasion". The warning tell me that a user may have...

Many thank for all your help it was a missing libray file which I have now replaced, all now works fine. again many thanks Steve

Sorry to be a pain but I'v just tried it again =Today() returns #Name? as does =Date() or Date() without any other parm? This happens when on my form, new record is selected and the date is my first entry field which is normally the current date. So to help user enter info quickley I wish it to...

Sorry to be a pain but, Today() gives same result, DATE(year,month,day) tells me "the expression you entered contains a function containing the wrong no of aurguments"

I have a date field formatted to short date which I need to default to today's date when adding new data. The problem I have is that =Date() is set as default but the value returned is #Name? not the date. If I use =Now() I get the date and time value BUT I only want the date. any help...

ok thanks, its a bit beyond me at this time, but maybe in the future.

How can I send via email an access report to Excel without loosing the formatting. Is it possible to setup and specifya formated template to send the data into? then email user who need this report don,t have access and dont,t need it, but will give a lot of agraviation if the reports are not...

Linking the tables as Wayne suggested worked fine, just for the record I was looking in the correct place and I have tried to install the wizards again but to no avail. thanks anyway best wishes and happly new year

Worked a treat thanks Steve

Can anyone advise me how to get my ADDIN's to work. I have split my database tables from the objects and moved the tables to the network server, but I cannot re set the file (tables) locations. The ADDIN manager on the tools menu is blank and I dont seem to have the Addin described in the help...

Thanks Problem Solved

My problem is with Access itself or probabably just the setup. When in design mode working on FORMs if I try to position a Command Button on my form it just sits there. It used to open a dialouge box with various controm options. It does on other PCs in the office but won't on mine. I can right...

Thanks to everybody whos replied and for all your help, I do have the default set at =Date(). It appears that it when users are browsing or adding a new record that this occurs. (I have a form that has date fields DUEDATE is when the vehicle is expected and is entered by one user the previous...

Thanks but the settings are ok, and the field acts and records normally most of the time. It seems to happen if a null value (just a return) is entered by the user when adding / editing records. :confused: