I have a form that I need the user to be able to choose what ever they want to fill in to manipulate the query. Currently I can only get a few combinations to work. All combinations require the date range and the employee id range. Currently I can only get the combination of the jobNo to work...
I have a form that I input records. It doesn't allow me to save a record because it is not auto populating the field with the automatic number from the sql backend. When I open the form it opens on a new record. How do I get it to automatically assign the number so it will save a record?
I have a table that is created and dropped each week. It is used as an export to populate and update fields in another program. Unfortunately one table has the field as a memo and the table it is going in is a number data type. I manual change the datatype of the memo field to number before I...
I have a crosstab query that I need the date to be taken from a form when it runs.
This is the current code.
TRANSFORM Sum(HrsForCrossTab.Hours) AS SumOfdHoursWorked_qty
SELECT HrsForCrossTab.EmployeeId, HrsForCrossTab.JobNo
FROM HrsForCrossTab
GROUP BY HrsForCrossTab.EmployeeId...
I have a work table which has two fields in it, a person's id and the deduction description. The person's Id is the matching field in all records. Basically I could group on this field if the other field was a sum or some sort. However the Deftinition is text and I need to create a string of...
I am fairly new to crystal reports. Here is the situation. We use a canned program that creates crystal reports. I can modify the reports but the data coming in is something I cannot change on the backend. Basically the crystal reports data is a temp table that is created by a procedure and...
I have a field on a report that references a query. if the query produces an empty results list, I get a null value in my field. How do I set this property to place a zero in this field if the value of dlookup is null?
=dlookup('comm', 'qryInvoices')
Thank you for you assistance in this...
I am having a brain lockup. I have been writing this program using alot of sql updates to make a work table. Right now I am coming into a problem with a calculation on commissions. Here is my problem. I have a commission database that salesmen recieve a commission when a payment comes in on...
I am trying to restrict what a user can see and edit on an access form and reports. My front end is Access and the data is stored in SQL 2008. I was thinking that I could make the view restrict what is seen by using windows authentication in the criteria. Basically, my users are supposed to...
I need to write code to modify a make table query through code. What this should do is look at the values in a list box and take those values as the criteria as what jobs appear in the table. Then I will use that table as a joined table in the rest of my program. The problem I am having is...
I need to create an import specification on an excel file that a user can type in the month and year..
Here is the situation. I have a report that is created in excel every month. I wish to create a command button that will bring it in. the excel sheet always starts with %com than the month...
I have created a form where a user fills in several boxes as parameter criteria in the query that populates a report. Currently the criteria in the query has a between statement, giving the user the information for the jobs that are in that range. The user wants to be able to select, lets say...
We have a field in a table that's data type is Text....The users of this field put a date in it until the unit is loaded on a truck and switch the date to "LOAD"...This apparantly is why it is a text field and not a date field....I have a user who needs a report based on when and what dates are...
I have a field with an id number. The table has 145 records. I would like to update that id number field with consecutive numbers. For instance I would put in a number in record one and then I would like each consecutive row to update that field with the next number.
Any ideas would be...
I need some advice on how to handle a coding situation that splits a record into two or more records.. Here is the situation...I have a program that imports invoices and payments on contracts for a given period. Each Contract has a "contract type".. 01, 02, 03 etc...based on the contract type...
I am not sure if I am writing the correct syntax for this code
=(DLookUp("Balance","[tbl_ats_SlsRep]","Sls_RepId= [tbl_ats_SlsRep]![Sls_RepId]"))
What it is trying to establish is get the [Balance] from the table [tbl_ats_SlsRep] Where the reports [Sls_RepId] is the same as the table's...
I have a report that calculates text boxes. If a report has no records then an error appears where the text box calculation is. How do I get this to either display 0 for no records or just blank in those fields?
What syntax do I use to count the distinct number of employees. I created a report and the report my have many employee id records. I am trying to count how many employees worked that week. I tried =count([employeeid]) in the control source of the text box, but that counts up all the records...
I have a form that has 8 tabbed pages to it. My user would like the tab to change color when it has the focus. Does anyone know how to do this?
Thanks in advance for any help
Micki
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.