Search results for query: *

Last week I was modifying portions of two modules in an access 2010 db when the program crashed, and would crash every time I tried opening up the db thereafter. I was able to create a new database and import the tables and queries from the corrupted one, but when I tried to import the...

I've got a form with a table where the user enters an employee id into the first column and upon exiting the cell the below script is triggered which populates the other columns in the table with the employee's information. The problem I'm having is that the code works on the first row of the...

I'm about to start building an xml form with a table where the user enters a name and number of hours worked. The name field will be a drop down box with all authorized names. How do I prevent the user from entering the same user multiple times in the table? On a side note, how do I retrieve...

Hello all, I've been trying to figure out the logic for this, thought I had it, then couldn't write up the SQL correctly, so I'll ask here. I'm trying to send a letter to a list of employees notifying them of changes to the way they get paid. Details EMPL_INFO table contains employee ID and...

I'm not sure which forum to post this on since it overlaps several topics, but hopefully someone here can point me to the best solution to this problem. Here's the situation. I've got two tables: empl_info and location. Within the info table lies a field called location option which notifies...

I have a button that will transfer the results of a query to a formatted text file. Here's the code,it works fine. Public Sub BatchButton_Click() Select Case MsgBox("Create Batch File?", vbYesNo) Case vbYes DoCmd.TransferText acExportFixed, "BFQ_EX_SPEC", "BATCH_FILE_QUERY"...

I have a list of employees that need to be sent a letter if they meet a certain criteria. The report looks at a query and prints out a letter for each employee that needs one. I want to be able to update their record with the date the letter was printed on. I think I have the code to get this to...

I have a main form called MAIN_FORM and a sub form called RESULTS_SUB. The main form will have some check boxes and combo boxes for the user to choose from. Based on the users choices the subform changes after pressing a button. The subform contains all records from two tables. My question is...

Private Sub Preview_Report_Click() Dim stDocName As String Dim strWhere As String stDocName = "Replacement Debit Card Transmittal to Unit" strWhere = "[New Card Number]='" & Me![New Card Number] & "'" DoCmd.OpenReport stDocName, acPreview, , strWhere I'm using the...