Search results

I have a table (tblLeaveData) with the following fields PERNR (Long) LeaveDate (date) SickType (text) DrNote (YesNo) SickType will have the following values: "S", "SF", "SD", "SFD", "SPre", "SFPre", "FM" I need a query that will filter out any "SPre" or "SFPre" where the corresponding DrNote...

I have a report that I need to show only the employees that meet a certain set of criteria. There are 3 tables used for this report. The first table is the Employee table that gives the specifics of the employee. The second table is the Sales Data (tblSales) that has the employee ID, Sales date...

I have an Access database with a button on a form that when the user presses the button, there is some VBA code that checks to see if Excel Is running, opens Excel, get the data from the spreadsheet and then closes excel if it wasn't open before. The problem is that when this process is...

I have a form that calls a function in a module that opens a spreadsheet, looks at the value of one cell and returns a variable. Then the code continues and does a similiar thing. I call the function in the Module from several different forms and that is the reason I have it in a module. The...

I have a field that I need populated based on a couple criteria. The report is based on a query. I can get close. From my understanding, a Switch statement will return the first True value, but evaluate all expressions. I can't get it to work quite correctly. The query has a field VacBid that...

I have an Access 2007 program that I put an Export to Excel button in the Quick Access toolbar. When I move the program to a computer using Runtime, the Export button does not show. I have looked through the forum and have not found a solution. I see posts where they talk about making a custom...

I have a report that is derived from a table (tblDocs) the structure of the table is: EmpId docType docDate comments (number) (number) (Date) (text) This table will have several entries for each employee. There will only be a few times that a comment will be entered. On my report, I...

I have a report based on a simple query but the report only shows every other record so I only get half of the reports I need. I am sure it is a simple setting somewhere but I cannot find out why. Here is the database. There are 14 employees in the table, 14 employees in the query derived from...

I have a form that is bound to a table (tblBids). On the form is a combobox that is bound to a different table (a list of all employees and their employee ID) The employee id is a text field. When the user selects an employee in the combobox the form is set to the bookmark for the appropriate...

I have a control on a report that I need to set the properties to get the following data. The report has a textBox control called EMP_ID and I have a table called tblDocsIssued. This table has the fields EMP_ID, docDate and docType. I need to get the comment that has the most recent docDate and...

I have a form that I want to be populated with bound textbox controls. The record source for the forms is a query and I believe my problem is that the query in not able to be updated. To get the query I have a table (TablePositions) that has FacilityID as one of the fields. I then have another...

I have a report that is bound to a query (qryReport) in this report I have a few textboxes that I need to get the data from another query (qryTop2Dates) I tried to use the DLookup function but I couldn't get it to work. :banghead: qryTop2Dates has the following Fields: EMP_ID 'used as an...

I have a table that is used to track staff training. This table has 3 fields: EMP_ID (Staff ID number) docType (identifies the type of training, will be a number from 1-4) docDate (identifies the date that training was given) Staff can be trained several times on the same training type...

I have a report that I need to include data from another table. This table lists training dates for an employee. There are 4 types of training (1-4). The query for the report has several aggregate functions and that works properly but I don't think I can join the other criteria to the report...

I have a DB that was written in Access 2000 that works. When I try to run it in Access 2003 it doesn't work. I tried to convert it from 2003 but that did not fix the problem. The form has several controls (text boxes, checkboxes and combo boxes) The form controls are populated from the result of...

I have a db with a table for staff (tblStaff) and a table for incidents (tblIncident) I have a form for creating a new incident. After you create the incident, you can add a staff member(s) that were involved in the incident. What I want is a combobox that has the list of staff in tblStaff but...

I have a form that has a combo box. I want to use the combo box selection to populate the form. The problem seems to be that the Field that the combo box is using is in the form of A-12345. One letter, a hyphen and 5 numbers. I have tried a few different methods that have worked in the past but...

I have a form (frmIntelInfo) that has a combo box that I want to populate with data from a table (tblAKA) that is filtered by the text in a textbox (txtID) that is on the form. The combo box does not populate with anything. I have the properties for the combo box to populate via the query...

I have two tables (tblRoster and tblAKA) tblRoster has the specifics on each person (ID#(unique identifier) Name, Address, Phone) tblAKA has the ID# and nicknames, sometimes more than one nickname for a person. I need a query that will join the two tables BUT I only want one entry for each...

I have a form (frmSearch) with a couple of listboxes (lstSearchName, lstSearchNickname).When the user double clicks an item in the listbox a new form opens up(frmInfo) that is populated by a query (qryRoster). From what I have found, is that you can not use a variable in a query but can...