Search results

I am wanting to use a master table to add a piece of equipment to and when I add that piece of equipment in the master table I want it to populate in multiple other tables as well. Is that possible?

Is is possible to have a form command button add data into several columns in a table through vba?

I would like a date field I have set up to auto populate the current date when I click on another field to enter information.. how would I do that?

I have a text box linked back to a table and I am needing to be able to make multiple entries at one time for this text box but when I enter the first number and hit tab all the other text boxes that are linked to this one in the table show the same number....

Is there a way to make a text box populate a predefined number based off what time of day the form is opened?

Just upgraded to Access 2010 and now when I open a vba window... all of them open not just the one I need. Is there a way to stop that from happening?

What steps do I need to take in order to convert a 2007 database into a 2010 database

Will Access 2010 open Access 2007 databases and allow me to function within them normally? I am being told that Access 2010 will not work with 2007 databases.

I am needing help with some queries. I currently have a PM form that duplicates the daily records so I was wondering if someone could look at these two queries and tell me if anything in them might cause duplication. The first is for a daily pm list: INSERT INTO [PM History] ( [PM#], [Last...

I created a command button from using the wizard so when I click to delete the record the button is for, a window pops up asking if I am sure I want to delete the record. Is there a way to not have the button pop up? Here is the code: Private Sub cmdCompleted_Click() On Error GoTo...

I currently have this code that opens a form when the button is pushed, Private Sub cmdWorkOrder_Click() On Error GoTo Err_cmdWorkOrder_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "New WorkOrder" DoCmd.OpenForm stDocName, , , stLinkCriteria...

I created a form that when it opens it shows data from a query linked to a table. On the form I have a command button to opens a workorder form that is used to create work orders. How can i get the information from the new form when it opens to be copied over to the work order form when I click...

I was wondering if Delinquent: IIf(Date()>DateAdd("d",[Date Generated],[# of days]),"Y","N") this means....... If the current date (Date()) is greater than the DateAdd- which is a combination of the day, Date Generated, and # of days = yes this it is deliquent otherwise it is not?

I was wondering.... If I wanted certain forms or reports to print out at a certain time each day without any user interaction where would I go to do that? Would it be in vb code, in the actual form or report, or somewhere else?

I have a switchboard that has been in use for many years. Within the main switchboard I have many sub pages that open forms, etc. On one of those pages I added another option in order to open a form, but when I go to use the switchboard and go to that page, that newly added option is not showing...

I am trying to print some reports through vb Private Sub Command173_Click() DoCmd.OpenReport "Daily Production Rpt -1st shift", acViewNormal DoCmd.PrintOut DoCmd.Close acReport, "Daily Production Rpt -1st shift", acSaveNo DoCmd.OpenReport "Daily Production Rpt -2nd shift"...

If I have a procedure that says Private Sub Form_GotFocus() DoCmd.Maximize End Sub and a procedure that says: Private Sub Form_Activate() DoCmd.Maximize End Sub within the same forms vba, dont they do the same thing by making the form they reference the maximum size?

I was hoping someone could explain exactly what is happening here with this procedure. Public Function OPEN_SESSION() As Boolean Dim objSession As Object Dim strServer As String Dim strMailFile As String 'Outlook must be open for module to work correctly If MsgBox("Do you have Outlook running?"...

I am studying a book trying to learn vba and in the book it says, "To clear the text box of all contents, simply assign an empty string, also known as empty quotes, to the text box's Value property. Example: me.text1.value = "" My question is... where would I actually put this line of code...

I was wondering if someone could tell me exactly what this does: Private Sub Form_Load() Me.ReqPanel.Visible = Config.IsPxManager DoCmd.Maximize End Sub Also I understand what the Me. keyword does but where does the ReqPanel actually come from? I thought it was a property of the form...