Search results

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...

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 | |...

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?

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...

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...

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)?

Hi everyone This seems like a really simple problem, but I can't figure it out... -I have a table that contains machine problems, and their duration times -I made a query that filters the problems based on the date of occurance, and adds up the duration times for a specified problem for the...

Hi all, I am utterly unsure if what I want to do is even possible: I have two crosstab queries, qryRewCOCredit and qryWrapCOCredit which show the changeover (CO) times for the specified machine when they are NOT zero. (all zero entries don't show up). There are many cases when there is a CO...

Hi -Is is possible to make a parameterized cross-tab query? I want only to display data between certain dates and for a specific crew. -Also, for data in the query I have the Line number (of the machine) as the row headers and the Problem names as the column headers. I also want to display the...

Hi Is there a way to carry over data input from the previous record into a new record? I have a combo box which users input a line number. When a new record is added, I want that same number to appear by default into the line combo box (but is still able to be changed if needed) Is there a...

Hi! I'm a first time Access user and I have a question about cascading combo boxes (I already tried following the other thread about cbo boxes, but no luck): -I have a main form, frmCommon -within that I have a sub form, frmCmnDetRew (Common-Details-Rewinder) -within that I have a sub-sub...