Search results

It doesn't matter because the calculations are made from the records themselves, regardless of which table it came from. I figured out a solution by making a query by "union-ing all" the two full tables, and then adding calculations in on the unionized query. Thanks for your help!

I have two tables, and I made a union query (tbl1 UNION ALL SELECT ...tbl2). Problem is, I have two entries that are identical in both tbl1 and tbl2, but I want to include BOTH of them in the union query. Even though I used the ALL operator, only one set shows up!! I'm pulling out my hair trying...

do you mean to put the filter on a table instead of the FORM?

Hi everyone I'm relatively new to MS Access, and I have no experience dealing with workgroups and user-security. I have a database that I need to put on the company network. The database will be accessed by many different users and computers. How do I set up the database so that only certain...

Hi I'm new at programming Excel, so I apologize in advance if this is really elementary. I want to fill in all the empty cells with the value '0' only if the empty cells are between two non-empty cells less than 4 cells away. Otherwise, the cells should be left blank. I.e. for: 5 | 6 | |...

Bob, here is what I have as my rowsource for combobox #2: SELECT tblName.LineID, tblName.Name FROM tblLine INNER JOIN tblName ON tblLine.LINE_ID = tblName.LineID WHERE (tblLine.LINE_ID=[forms]![frm]![subfrm].[form]![cboLine].column(0)); Keith, I still get the same error message about an...

Hi all I have searched through this forum and on google, and I know that I can refer to a combobox's column property IN VBA by [myform]![mycombobox].column(1) When I do this in SQL, it complains that there is an "unidentified function" (column). What am I doing wrong?

Thanks for all the help, ajetrumpet. I really appreciate it! I thought about having two separate queries (one for each of the changeover types) and unioning the two (so the act. and std. would be on one record), but I thought that there would be a simpler way that I might have overlooked. In...

When I use "Act." I mean actual changeover, and "Std." to mean standard changeover. Simplified example of what I have: Date Problem Name Duration 09/05/07 Act. 120 09/05/07 Std. 100 09/10/07 Act. 90...

Act. and Std. are in the same field. The reason for this is because Act. and Std. change-over times are a subset of Machine problems.

Hi everyone! I have a report based on a query which shows the actual and standard change-over times. Is there a way to get Access to show the difference (or (Act.- Std.) / Std. ) for every Act. and Std. change-over pair? Thanks in advance

I have two tables: tblOne and tblTwo with identical categories. TblOne and tblTwo both group by Category and Duration. When I make a union query between tblOne and tblTwo, I notice that if I have the exact same category and duration for BOTH tblOne and tblTwo, the union query "eats up" one of...

The names all are correct..

I know this should be very simple, but I've already tried every possible entry from the site given in the FAQ section of this website (http://www.mvps.org/access/forms/frm0031.htm), but it keeps access keeps asking for a parameter value!! i have a subform(frmSub2) on a subform(frmSub1) on...

Does that mean I don't have to make the frmProblems subforms of the frmDetail subform, and can just do what you told me above? (Which, btw, can you please explain further? I'm a beginner at Access)

now that you mention it, it DOES make a whole lotta sense to make the forms subforms of the subform. Thanks!

Here's a simplified version of the database. When you select the line in the frmLineDet (line detail), the DetailID appears in each of the problem forms (the ones along the bottom). However, when you select a new line in the PROBLEM forms, the DetID doesn't match the DetID for the line in the...

DetailID and SheetID are both autonumbers and PKs. The SheetID is automatically filled in on frmProblem because there can only be one sheetID per record on frmMaster. However, there can be more than one DetailID (there would be 10 detail forms filled out for 10 operating lines for example)...

i have a form with two subforms. say, frmMaster (parent), frmDetail and frmProblem. frmDetail and frmProblem are connected to each other by DetailID and both are connected to frmMaster by SheetID. I made it so that when the user selects a new record in frmDetail, frmProblem has its DetailID...

Hi everyone So far I have the code that successfully exports an Access query into Excel when the user clicks a button on a form; how do I make it so that somewhere on the spreadsheet is the values entered into two textboxes on the form (start and end date)?