Search results
-
M
Sorting by month
I have looked and tried a lot of things that I have seen in this forum, but I am not able to make this work. I have a query that I am trying to sort a table field, "Date" by month. The field has a "General" time/date format in the table. This is the last code I tried, but as you can see I am not... -
M
need criteria to show last 5 records
Is there a way to put criteria in a query that will choose the last 5 records that have been entered into a table. I want to make a query that will allow me to average the last 5 records from a table. The field that has the data is updated frequently. -
M
Automatically backup database
The database I am referring to is a split database on a LAN. I have a little knowledge of Access, but not much. Currently I am making a copy of the database file (database.mdb) to a different folder every morning for viewers to look at the plant data. It appears to be helping the balloning of...- mrbebop
- Thread
- Replies: 7
- Forum: Modules & VBA
-
M
Problem while compacting and repairing
I tried to compact and repair my database but near the end of the process the following box appeared. I have never seen this before. The database did not compact. What does the statement mean and any ideas as what I should do? Thanks everyone for your help.:) -
M
export data from form to an excel spreadsheet
What is the code that would have a command button export all the data from a form to an Excel Spreadsheet. The users do not have the option to choose "File" and "Export" the data from the form. I am just assuming that a command button is the best way to do this. If a macro would be better, then... -
M
Automatically insert record # into field
On my form I have a field that is using the record # as part of a lot # for our product. Presently a combo of letters and #s are manually typed in the field that I am speaking of. A lot of mistakes are being made and I would like to have the information to be put in automatically. I have changed... -
M
Create a records delete button on a form.
I have a form with several fields that give information to people in production as to what is needed from them to fill orders. Upon completion of these orders, there is a check box in each record that they can check when the particular order has been filled. I would like to create a button on... -
M
Hide the menu bar and toolbar?
How do I hide the menu bar and toolbar so that they are hidden form users in a database? Also how do I open the database with the menu bar and toolbar unhidden in order to make changes? Thank you for your much needed help.:)