Search results for query: *

This thread is related to thread149-1402780. I had a problem of exporting an Cross-tab report to excel and did not want the export to excel data only option (since I had some cells highlighted in different colors and wanted to retain the cell formatting). I found that if you right-click on the...

The code below (see code that doesn't work) gives me a error "syntax error in union". Once I click ok it highlight the bracket in ") as Q1". The strange thing is if I break this query apart then it works. There must be something wrong with my syntax surrounding the aliasing. I would like...

I need a query to populate a column based on criteria in table. The criteria is based on 2 dates. I have 2 tables: employee position table and an assignment table(where the employee is scheduled to work). I need to add another column to the assignment table that displays the person's positon...

I am using crystal 8.5 and need to find persons where a record does not exist. I have two tables, person table and a certificates table. I need to find persons where a certificate does not exist for that person. The certificates table creates records when the person has acquired a...

I am using crystal 8.5 and need to find persons where a record does not exist. I have two tables, person table and a certificates table. I need to find persons where a certificate does not exist for that person. The certificates table creates records when the person has acquired a...

I have a parameter called Choose a competency and I have allowed multiple values. I have entered the default values in for this parameter. My record selection formula will look at the string selected and then select the records belong to the right group number. If user selects multiple...

Hi everyone, I am a new Access user, and don't really know how to move about the application. Is there any way to save attachments (documents, e-mail, business approvals) in an Access form? They would need to be retrieved for later use. If yes, how would I go about doing that? Thanks...

I have an access database with an enforced primary key on all records. Users of this database wish to copy fields from one form/record to a new form. How can can I create a duplicate form without causing issues with the primary key?? Each form has a unique primary key and by replicating the...

I am searching for a way to set up reports to run in the US and in London. If the printer specifications are hard coded in the report, then we need two sets, we don't want that. If we let the report use the default printer settings it switches to the correct size of paper but the orientation...

I am searching for a way to set up reports to run in the US and in London. If the printer specifications are hard coded in the report, then we need two sets, we don't want that. If we let the report use the default printer settings it switches to the correct size of paper but the orientation...

I am searching for a way to set up reports to run in the US and in London. If the printer specifications are hard coded in the report, then we need two sets, we don't want that. If we let the report use the default printer settings it switches to the correct size of paper but the orientation...

Hi, How do I build a form that queries using multiple combo boxes? I am trying to create a form that functions like MS Excel Advanced Filter function. That is, I have a table with the fields: Country, State/Province, City, Location. I want the user to pick the Country in the first combo box...

Hi, How do I build a form that queries using multiple combo boxes? I am trying to create a form that functions like MS Excel Advanced Filter function. That is, I have a table with the fields: Country, State/Province, City, Location. I want the user to pick the Country in the first combo box...

Hi, How do I build a form that queries using multiple combo boxes? I am trying to create a form that functions like MS Excel Advanced Filter function. That is, I have a table with the fields: Country, State/Province, City, Location. I want the user to pick the Country in the first combo box...

I am trying to do a simple query to count records before the year 1995 and with no education ID. I am having problem with the date expression. Cna some one help? The date format that appears in the table is yyyy-mmm-dd (2001-Jan-01) SELECT Count(dbo_patient.patid) AS COUNT...

I have a form that displays all the current 5 employees. How do I create a button so that I can exit the form and not save the changes. The problem is that each row is a record. DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_UNDOFIELD, , A_MENU_VER20 DoCmd.Close A_FORM...

I created a cancel button on a form with a subform. My main form (client info) and subform allows for edits, additions and deletions. My subform allows many entries (aliases). If the user decides to cancel the changes he made to a record than he/she can press cancel to undo. I want it to undo...

I created a cancel button on a form with a subform. My main form (client info) and subform allows for edits, additions and deletions. My subform allows many entries (aliases). If the user decides to cancel the changes he made to a record than he/she can press cancel to undo. I want it to undo...

I created a cancel button on a form with a subform. My main form (client info) and subform allows for edits, additions and deletions. My subform allows many entries (aliases). If the user decides to cancel the changes he made to a record than he/she can press cancel to undo. I want it to undo...

I have a form to enter client information. There is also a subform in the client information form. I have created an edit button to take me to the client I want to edit. I have a cancel button to get out of the form without changing the information. I used this code...