Search results

Have you checked the properties of the file to make sure that it is not set to read only? Right Click on the file Select Properties and at the bottom of the window in Attributes make sure that there is no tick in the Read Only box.

Sounds like your query is the problem, go into the query and see if you can enter data dierctly into it, rather than the form. My guess would be that you are unable to enter records this way either, which means that your query is the problem. Have you based your query on more than on table?

I don't think that you can add that to the query, the best option is to create a form or Report based on your query and do the sum in that. Regards Pete

Make sure the database is not set to read only. If you right click on the .mbd file and look at the properties and make sure there is no tick next to read-only. Or Start Microsoft Access and then select Open, browse to the file you wish to open select it then just next to the open button you...

Have you tried to hold down the shift key when starting the database? This will cancel the normal startup. Regards Pete

Hello, do you meen that the results are appearing incorrect? if so have you tried turning on the Precision as displayed option? Tool --> Options --> Calculation Regards Pete

In the code for the delete button, I add the line: Me.Recalc Don't know if this is the correct way of doing it but it works for me. Regards Pete

Thanks for your help. Pete

Excellent, Thank you. Regards Pete

That looks great. Question: How do you get the forms to open in a specific location? Everytime i open a form it opens ontop of another and i have to move it manually. Is there a way to specify the location it appears in on the screen? Regards Pete

Hi, I have a button that creates a folder, but if the folder already exists it comes up with a Run Time Error 75. I have the following code to try to stop this but it does not seem to work. Does anyone have any sugestions on how i can fix this. If DataErr = 75 Then MsgBox " Already Exists"...

I have never had any problems using compact and Repair on closing the database. It is good for keeping the database's size small. The only downside I have come across is that it takes Access a little longer to shut down as it is running the compact and repair in the background and people tend...

Fantastic! This example is fantastic! It is a really useful tool. Well Done Regards Pete

If you put a text box on your form and use the calendar as the control source you can set the format the textbox to dddd This will show you the day of the week. Regards Pete

Thank you, I did not think about doing that. Kind Regards Pete

Sorry the Field is linked to a query, so the number i type in the unbound box is for that query. Parameter is : Forms!F_InputHours!Hours I dont want it to save the record as the number changes depending on what i'm looking for.

Alan Pardew

The post is no longer there, does anyone have this? and could they re-upload it. Regards Pete

Hello, I'm having a problem with one of my forms, i have created an unbound text box called Hours. In it i will type a number. Then click on a button to create a report based on this number. what is happening though is that when i click the report button the report is blank, if i close the...

Hi, Your best bet if Possible would to make your Code field a Primary Key in the table. If not a primary key, then set the field propeties of Indexed in the table to Yes (No Duplicates) Regards Pete