Search results
-
M
List associated values in one field
Hello I am trying to list associated values in one field as filtered by a query, but a little more complicated in the presentation of this information. Here is an example: TBL-1 ID: EMPLOYEE: LOCATION: == ========= ========= 1 Hernandez New York 2 Brown Arizona 3 Valdez California 4 Smith... -
M
Append Query works, but Table not showing records until db restarts
Hello all, I have a form that is used as a sort of transaction window. Through this form I am able to connect records in a many-to-many relationship. I do this through a form and use an append query to make the relationship. The append query appends the primary keys of both tables as foreign... -
M
Do not allow entry in textbox depending on Combobox Selection
Hello all, I have been looking for a while, maybe I am not phrasing this correctly. I am working on a survey and I have a combobox where the user is asked a yes/no question. They choose yes or no. If they choose 'no' then they can explain why they chose 'no' in the following textbox, but if... -
M
Update Matched Records
Right now I have an update query that does not seem to be working. The update query is updated information based on two tables. The query has two fields it looks at: StockNumber and Description. So where [Table1]![StockNumber] = [Table2]![Stocknumber] and [Table1]![Description] =... -
M
Double Click Listbox Record to Run Update Query on selected Record
Hey all, Does anyone know how to run an update query on a specific record in a list box upon double-clicking on that record? Thanks -
M
Browse, Import, and Map Spreadsheet from Form
Hey all, I am working on this database and I was wondering how to 1) Browse to find the spreadsheet I want to import 2) Import this spreadsheet through the same form that I browsed for it 3) Map the column titles to the table already created Any help is appreciated. Thanks! -
M
Populate Table Between two numbers
Hey I have been looking through the forums, but I have not found my specific code. What I am trying to do is based on a length of time, say 24 weeks, I want a table to be populated with a count of 24 weeks, but this count will start at week 9. So it would count week 9 through week 33. And then... -
M
Charts outside of Access
Hey all, I am trying to create a report and I need to use a chart that MS Access does not have, but MS Excel does have. Is there anyway to get charts from MS Excel into Access? Or does anyone know of any website where I could download charts? Thanks! -
M
Dynamic Graph in Report
Hey all, I have a report that reports issues per month. In this report the issues are separated into issues per day - that is open issues, opened issues, closed issues, and overdue issues for each particular day. This is all put in the graph. This is fine. The graph reports every 7 days and... -
M
Autofill table?
Hey all, I have a report that reports issues per month. In this report the issues are separated into issues per day - that is open issues, opened issues, closed issues, and overdue issues for each particular day. This is all put in the graph. This is fine. The graph reports every 7 days and... -
M
Subtracting dcount from dcount
Hey all, Is it possible to subtract dcount from dcount in a query? I am so far unable to do this. My code looked like this: Expr4: DCount("[Index]", "tblGPR", "[tblGPR]![ReceivedDate]") - DCount("[Index]", "tblGPR", "[tblGPR]![ClosedDate]") I would prefer to have something like this... -
M
Start and End Date Count Records Open per Day
Hey all, I have a database that tracks specific issues. The issue comes into the office on a specific day (OpenDate) and is closed out on a specific day (ClosedDate). What I am trying to do is create a graph from a query that shows Opened issues by date, Closed issues by date, Overdue issues...