I want to set a simple page just to Stop user to add a new page, I just want the one sheet. Main reason is I have a table with two colums. when the user begins entry and reaches the end of the table colum it goes onto the next page which I don't want. How is this done?
I have created Hyper links which opens PDF files. It opens the files from the Laptop where the databse sits and the folders which contain the PDf files.
When moving the database to another Laptop, the links do not work. It is copied over to the same location as it would sit in the Primary...
Is there a formula where a User is prompted with a some form of warring as to when a the due date arrives.
I am trying to get the Cell to change its colour When there is just 3 months left to when the due date arrives. And once it get a new date inputted it reverts back to its original colour...
How do you create a field, which will automatically assign a number to the record? I wish to have a number which will also include the year for example “1/2006”. Also once the year has ended it automatically changes the year and starts from the number 1 again e.g. 1/2007 and so on.
How do you reset the Autonumber field so it starts from number 1 again. Also just when you delete a record it tends ignore the record number completely and jump to the next number rather than using the number just deleted. Is there a way around this?
I would like to know if there is away to Find and Replace data within a Table i.e. I would like to Replace a field which is the same for all entries in the table. For example All Users on the Database Belong to Area 12, but now has changed to Area 19. Is there a SQL code which can replace...
Need help!!
I have an error appearing when i try to insert a picture into a record. It was working previously and now its has an error. the steps im taking are
-Insert Object.
-Select Choose from file.
-Select the location of the Picture.
-Click OK.
-Following error displayed.
"THE...
How do you set a Maximum number of Records for a form to be entered. i.e i do not want the user entering more than 20 records for this form permanently. also if the user tries to enter more than 20 records an error message should appear explaing why and what to do.
Can this be done??
I have places two toggle boxes on a form. When you select one of them you cannot alter your choice unless you exit the form and return to it. how do you reslove this??
I've seen this example within Microsoft access HELP!. I want to Create a option on my form for example YES or NO. If the User selects YES, the area is greyed out. If the user Selects NO, the area is enabled for the user to use or enter data.
How can this be done please.
Is there a simpler way to insert a picture into a form by a user. Other than right clicking th area and going through inserting an object and so fourth.
Im creating a result sheet for exams. I would like a toggle with PASS on it, to be automatically selected if the pass mark is 90% or above and FAIL if below 90%
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.