Search results

The points are there. I agree this is a bad habit. I am trying to use TransferSpreadsheet to import the data. Each file has a different name for the respective date and then I need to force an operator to specify date and then select transfer. Thank you, Wesley Morgan

I need to get data from an excel workbook and create a table in access. The customer is keying in data from a handwritten log each morning into excel. The excel is in a template that increments the pointer to the next row after each entry. Information entered is a value recorded each hour and...

I am building a report from a crosstab query. The operator will input the begin date and end date for the report into text box on a form. A control is set on the form to click for preview report. The begin date and end dates are used as criteria for the crosstab query that the report is written...

In working with the query that I am using for the report wizard, I find the following reactions. If I have parameters set to represent controls on form then report wizard cannot display the available fields from query. If I delete the parameters the fields are visible. If I put a criteria like...

What could cause the fields from a crosstab query not to be shown in available fields window of report wizard? I have a crosstab query that works great and list all data requested. When I try to use the report wizard to create a report from the query, none of the fields are shown in the wizards...

Please expand upon your comments. If I put the parameters value of the textbox control name or do I need to show forms and form name?

IS it possible to obtain the criteria for a crosstab query from a form textbox control? I am using linked tables in my database with two tables. Thank you, Wesley

I have solved problem. I am using linked tables in my database. I set a build table query and moved all data to new table. Form and report work great with new query. The question now becomes "Will the build table query update as needed to allow the crosstab query to work?" We shall find out...

The problem seems to be in the form. If I change the text box name on the form the change carries over to the query criteria. This tells me that the form name is being accepted. The text box name is not being recognized as a valid field. Should I do something different. Can someone take the time...

Rich, This is the SQL for the query. I am trying to create a switchboard to select different reports. The report based upon a date range would call a form to allow operator to input the begin date and end date. The form would set the criteria for the query and have a command button to preview...

Rich, I tried this and still get the same error. I set parameters for begin date and end date to date/time. get the same error.

I am trying to use a form to set the start date and end date for a crosstab query. The form has two unbound text boxes each named begin date and end date. The query has the following criteria " Between [Forms]![form name]![begin date] and [Forms]![form name]![end date]. I get the following error...

I am trying to set a form into the middle of screen with a size of 2.5" tall and 4" wide. The form comes up as full screen. What am I missing?

I have the crosstab query working. Now I need to place data in single row for the time field. I am getting each field of data in a seperate row and column Example: Date Time Data1 Data2 Data3 08/17/2003 10:20am 345 08/17/2003 10:20am...

When I define parameters in the crosstab query as Date/Time, the values in the other columns go crazy. Example: data would read as [ 457 ] is displayed as [ 355.002344657890 ] all values are effected except date and time. Can I set criteria in the field for the short date that would allow an...

I am new to the forum and still stumble into things as I go. I have tried the crosstab query and had problems with the criteria in the Date and Time field. The date was formatted to short date and I had the criteria set to prompt the operator to input the date for the report. In the select...

I need to get information from a database that has data in rows and display the data in columns. Columns would be Date ; Time ; Data1 ; Data2 ; Data3 ; Data4 ; ect... Data is now shown as Date ; TagIndex ; Values Rows are date; index number ; data value Example: have this now Date...