Search results

I had used some code found here a while ago to utilize with prompting a user to choose the filename to import. I've altered it with some things to work for what I need, and it works fine, except the filter for text doesn't work - all files show, even though the text ["text files (*.txt)] set...

Vassago/Pat--I had a feeling I would need to create a form. What I'm doing is taking a database someone else created and doing a user interface and automating things. Pat - refresh is what I need. I'm trying to refresh the dlookup textbox which simply shows a COUNT of how many records are...

I have a user form that is used basically to import data into tables, roll data up to a ytd table, etc. There is also a command button to open a table directly to do editing/deleting of records, etc. Next to each table name/option button I have a disabled textbox with a dlookup that counts...

I too am looking to be able to display a message box when there is no data in a report. But it seems that the nodata event occurs only at the point of formatting a report for printing. So, this does nothing when a user is just previewing the report. I am looking to have this message occur...

I did search before I posted my question. I know how to do it if the name and location of the database you're importing from is already known; what I'm trying to do is figure out how to automate having a user select the location, name of the database, and the table, and have it come into a...

I have a database which I have automated to bring in and append text files to a table; this is working fine as it prompts the user to find the file and then it uses the import spec to append to the table. (using docmd.transfertext) I'm now trying to do something similar, but by bringing in an...

Thanks for the tips - I didn't want to use DLookup or a subform though. I found a solution by using the following -- in case anyone else is trying to accomplish the same thing. In the text box that I want to use to display the name, I put the following, referring to the combo box that shows...

I usually design forms to view/export/mail reports, run things, etc. I'm doing this small project, should be a snap. But the simplest thing is holding me up, because I haven't done it in a while. This database is pretty simple, with two tables. -One table has the Customer's info (BP, Name...

That's the problem...I'm trying to put it in the page footer. That's what I'm getting at - is that something that can't be done - putting this in a page footer? I want the name of the report and the month/year to show up on each page. I have changed all the queries to have MTH, YR...

Pat, 1 - noted! That's an important point. 2-In this instance, [year] and [month] are fields from the report's underlying query, (in the query it is calculated from the date field). I haven't named these text boxes (still have default txtxxx, I just inserted them on the report have been...

This is one of those things that I do on the fly and usually have no problems but sometimes I have to redo it til I get it right. I'm sure it's simple, but just one of those things. When I'm adding a text box on a report and want fields to show up, I usually have no problems, but when I want...

I know, you're absolutely right. I got this thrown at me and then they are requesting multiple queries/reports, etc. which need to get out so unfortunately I'm operating on a "get it out now" basis...I'll need to fix these things so this won't happen again.

UPDATE: I got this working. Seems that someone put a "garbage" record in there, one that had all fields blank except for the customer number. I took that out and now it is working fine.

I have a report that is based on totals query (which is based on another query). This ran just fine on Friday, but today I'm getting the "data type mismatch" error. The base query, "qryProoflisting" runs just fine. This takes the date (which is a text field) computes the quarter, GP, etc...

Thanks again...just never came across this as I'm self-taught with Access. Since I'm using Access 97 I'll have to use those set of instructions. As I understand it, I'd really keep it the way it is (forms and query criteria), but add "forms!formname!ControlName is null" after pointing to the...

Thanks, I'll check that out! I've been using the criteria field in the query pointing to the form, and using VB to run stuff...kind of mixed. This is just what I was looking for, to move forward.

I've got the basic query down finally to pull the correct data for what I need. What I need now to do is have the user be able to run a report from the query in a variety of different ways, then have what they selected show up in the report header and footer. I know how to pull this data...

Thanks for your reply. But the concatenated field does show the combination of order and line, which would be (ideally) a unique field. I say ideally because I need to start all over again with this. What I found is the query was running slowly because the table with the orders has only one...

I don't know what the problem is with this: I have two tables, one is a billing table and one is a commission table. I need to create queries/reports with this data. Each have a field "order number" and "line number"; the order number may be on each table multiple times, with different line...

I was just curious...didn't mean to sound ungrateful... what you posted will help me a lot with this project and to build on it for others. Thanks!!