Search results

all reports are based on queries Bob: All of my reports are based on queries. Below is the SQL view of the query Can I just change part of the where clause to reflect your code. If I could get away from using [Forms]! then it would be easier to base the where clause on variables. Thanks...

To all: I have several reports that use dates to filter the data. Right now i am using datepicker to select a date and then store on a form variable. Then in the report data query I use >= [forms]![viewreports]![begindate] This works, but what I would like to be able to do is the following...

To all: When I click a button on a form I would like to display several choices as radio button selections ( see attachment) Then depending on the selection, the user could run different reports or queries. Any ideas on how to do this Thanks Charlie Crimmel

Export Access to DBF According to the help files, there is a transfer database command see attached jpg TransferDatabase Action You can use the TransferDatabase action to import or export data between the current Microsoft Access database (.mdb) or Microsoft Access project (.adp) and another...

This command works well for exporting an access table to excel. I cannot find the correct syntax to export an access table to a dbf file. Thanks Charllie Crimmel Access to Xcel DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "exporthist", "c:\exporthist.xls" Access to DBF...

Export Access Table to Excel and dbf This command works well for exporting an access table to excel. I cannot find the correct syntax to export an access table to a dbf file. Thanks Charllie Crimmel Access to Xcel DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "exporthist"...

store calc fields I still respectfully disagree, at least in this case. In a payroll application, Once a persons pay is calculated for the week and a check is written, the data should not change. It has to stay the same as the check was written or you will not be able to do the bank...

Why are you calculating tax liability in a report? Why not calculate in a table and then just print the report based on the table. I do taxes by running a Module and posting the calculations back into a table. Then the user can either look at the employees taxes on the screen or print in a...

Got List Box working I got the List box working with the Alpabet Bar When I select the letter, only those employees with the last name starting with that letter shows. When i select a name from the listbox I want to find the record and show the employee info on the right any ideas? see...

Thanks A listbox would probably be better. (If I knew how to do one) That Would save the rest of my form for the selected employee information For the last 14 years, I have programmed in other languages and just starting with Access Thanks Charlie Crimmel

We will try again I stripped all the other forms out

Paul: Attached is a zip file The form that I am working on is test empdata

All I get is Syntax error I have tried different things Right now I just get syntax error Some lines are commented out where I have tried sifferent things CODE: Private Sub LetA_Click() Dim str_Let As String DoCmd.SetWarnings False str_Let = "A" 'DoCmd.RunQuery "LetterA" SELECT Empdata.LNAME...

Thanks I have tried 2 syntax and get errors on Both Thanks I have tried 2 syntax and get errors on Both Give errors Any idea on what the syntax might be and how to refresh the form after the filter. =Left([LNAME],1) Like "A" also SELECT [Empdata]![LNAME], [Empdata]![FNAME]...

To All: First Post to this forum- I am trying to convert a payroll application that i wrote in another software to Access. My other application can calculate federal and state taxes, deductions,net pay and write checks. It has been in use for over 13 years. Someone ask if I could convert it to...