Search results

Like I said, I'm really confused because I've gotten this to work in other databases with no problems. I followed the same steps but it's not working.

How do I upload the DB?

Here's the SQL for the query SELECT Tbl_DataSizes.Size, Sum(Tbl_PickUp.Quantity) AS SumOfQuantity FROM (Tbl_Interaction LEFT JOIN Tbl_PickUp ON Tbl_Interaction.ID_Interaction = Tbl_PickUp.ID_Interaction) LEFT JOIN Tbl_DataSizes ON Tbl_PickUp.[ID_Size] = Tbl_DataSizes.ID_Sizes WHERE...

I tried replacing it with date() and removed the time portions from the table and I'm still getting nothing.

Yes I used the gui to create this. Give me a sec and I'll upload the SQL.

Now()

I have a query that has one column that groups names together, a second column that sums up the quantity of how many total units someone has received, and then a third column that has purchase dates in it that is set to "where". I am trying to set a criteria in the date column to show results...

I couldn't get the debug to work (I'm still pretty green on this stuff). I get a runtime error says type mismatch?

I tried the code and it didn't seem to work. Mind if I pm the db to you? How do I attach the it?

Lol I would like to just send the database but i wouldn't know how to trim it down. The name of the form that the list box is on? It's called FrmRent_Receipt

I can't get it to work now? I have limited knowledge about SQL and even less about how to use it in VBA.

Hey, I have a list box on a form that I would like to ba able to sort either by the person's name, receipt number, or by transaction date. I had found another forum post that suggested the person change the row source using vba when a button is pressed. I tried this method and it worked until I...

Yeah its still doing the same thing but I was able to figure out a work around for it. Right now it will do until I have a chance to remake that page. Thank you.

So just importing everything should fix it, it wont just import the corrupted data as well? I wont have to recreate things?

Hey, I'm trying to reference some information that is on a form using query but for some reason I can't. If I reference any fields in the form using a query I'll get random things like Chinese characters, blank fields, or for one of the number fields on the form will return "q" in a query. I...

So I've been messing around with it tonight. I was able to do the compact and repair. I was fooling around with a test query and can't get a query to reference anything that is on that form correctly. So I guess this is a form issue, so I guess I'll move threads. Thank you for you help.

I tried the compact and repair but it said that it could not use the file because it was already in use.

I have not. I've heard of that but I'm unclear what it does.

This is an odd one to me. I have an append query that appends 3 fields on a form to a table. It has been working well since I made if several months ago, up until I tried run it tonight. It will recognize 1 of the 3 fields with the correct value, 1 of the fields will have some funky Chinese...

The format code worked perfect. Thank you.