Ok, I am completely lost here. I currently have an access database used by multiple users. They enter 2 pieces of info into an access form, press run, and their report is generated. I have created this database - forms, queries, etc, so I am comfortable working with access. But now I want to...
I have created an access database for reporting purposes only. I have a link on my web page pointing to this DB, however, when I click the link I receive the message Pop up window "File Download - Some files can harm your computer.....................Do you want to open this file download...
I am currently using access to run several queries against data that resides in SQL tables. The problem I am running into is that when I am running queries the records located in the SQL tables become locked by me. Is there anyway around this problem???
I have created a fairly large database with numerous amounts of info. The drive I had it stored on just crashed recently and some data was lost. For future use, is there any way I can tell my database to automatically back itself up on a nightly basis to another network drive or local drive...
I am having trouble with the syntax of Dlast. My page opens and I have a field named auto_number that I want to be populated with Auto Number from Table Daily Health Check. Currently I have:
Me.auto_number.Value = DLast("Auto Number", "OLP Daily Health Check")
What am I...
Once submitted my form creates a record in a table, one of the fields in the table is Auto Number( generates random nuber, identifier field). On the second form I have a text box that I would like to be populated with the auto number from the last record created from submitting the first form...
I am new to access and I am having problems using this function. Basically I have created 1 form which stores data to a table with one field being the auto number field. On my second form I have a hidden field which I want the default value to be populated with the auto number of the last...
I have created one form which stores daily data in table A creating one record a day. Form 2 has a subform in it which stores multiple records of data in table B. I want to be able to run reports pulling data from both tables on a given day. I basically want my record stored in Table A to have...
I have created a form which contains a a title labe first then a subform, followed by some buttons which perform certain functions on the bottom of the page. When I call the page to be opened it opens at the bottom of the page. I have looked everywhere on how to fix this. Any solutions???
Currently I have created a form where a user will enter specific data concerning the upkeep of our systems. The system password needs to be updated at the end of the month. Currently I have a text box hidden, I want this box to appear at the end of the month. Any sugestions
Currently I ahve created a form where a user will enter specific data concerning the upkeep of our systems. The system password needs to be updated at the end of the month
I have finished creating a form which is linked to a table where all the data enetered in the form is stored. Data is entered in this particular form once a day and is recorded uniquely in the table by date. The problem I have is that when a user opens the form to enter data they have the...
I have just finished designing a form, and I would like to split the form into two seperate pages. Can anyone provide me feedback with how to use the page break function. Where to place it, how to navigate between the two pages.
Thanks
I am a fairly new user in access. I am creating a form with several option groups using check boxes. Basically the option box consists of a question and yes and no check boxes. The functionality I desire is when a user selects the "no" check box, a text box will appear for the user...
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.