Search results

Figured it out. Thanks anyhow.

I have a query that uses 2 Fields from a large table. Cashier and Date. The problem I am having is I would like the select a time frame, a Start and Stop date, and count how many times the cashier comes up for that day. Sounds easy, I would think so but having a problem. The dates are...

I am be so off track here it might make you laugh. I tried to work with SQL and Queries to get the results I needed but it isn't working. So I made a recordset a manipulated the data as I needed and stored them within an array. I would like these results now to be displayed on another form...

Can you paste the SQL code, or your VB code that calls the Query?

If you place an entry for the year 2004, does your Start and Stop date work for the year 2004? 1/1/2004 - 1/1/2005

Curious how the report is generated for the month of May 2005 to be exported to excel. It seems like you are asking to populate a date and year field, but yet you are able to generate a report for that time without the field already in the database?

I believe he wants the fields on the form to auto increase/decrease to fit the largest query entry. This features is used on Excel spreadsheets if you click on a column dividing line. It auto sizes the column to fit the largest entry in that column.

Is that impossible cause I am eliminating the repeated Vendors. Is the grouping possible. If the vendors need to be repeated, I would do that if I could.

I did a search for Gouping and sums, but nothing really helped me. What I am trying to figure out: I have a table where I am trying to use 4 fields in a query. Vendor, items, Cost, Date1 - I am trying to Group by Vendor, Sub-Group by Items (Easy, I did this) - Now I am trying to Filter this...

Yes I understand that there are many different ways to perform the same task, and when it is something simple (like reading a text file) go with what you know works. I added your Dim statement and it worked. But, I am a persistent when it comes to learning the reason why something doesnt...

Sorry didnt work I tried to reference that library and it didn't work. I then proceded to try other methods and pasted an example from the Access Help screen. Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f Set fs = CreateObject("Scripting.FileSystemObject")...

After 2 days of searching I am sick too my stomach from not finding what I needed. I simply do not understand how it is possible that everyone, including Microsoft, assumes people just know stuff. I have been wanted to read text files within an Access DB. The DB will extract key words and...

I am sure someone will find a shorter way, but this works just fine. Var1 is the field which contains ABC0029, or whatever. Dim a, b, c, d, final Var1.SetFocus a = Var1.Text b = Val(Right(a, 4)) b = b + 1 c = CStr(b) d = Len(a) a = Left(a, d - 4) For i = 1 To Len(c)...

OK I read read somewhere that access 2000 and newer version automatically default Dim rs as recordset as an ADO type, which was given me an error message on invalid type. So I changed it too Dim rs DAO.Recordset. So I now can play around with the query fields at will. Thanks for your...

I did a search and looked around, but not sure how it would be worded. Nothing I read thus far helped. I am sure this is so basic and simple, I just can't figure it out. I am trying to grab the data from a query and have it inserted into a subform of mine. The query has 3 fields: 2 fields...