Search results

Thanks Gasman!!!!!! Yes, thats what i was looking for. Only ONE more thing if you dont mind :D The first record has a different procedure. And so does the last. I would like to do something at the first record and then start the loop for the others. Also i want to stop at the second last...

:) Alright. Well i use a text file on my own (development) laptop right now. Just to see if the strokes work at all. Seems to be fine. I just need to loop through all the records on the form.

Thanks guys. But im afraid my hands are bound. I cannot create text files or save them to any location on this network. I only have a warehouse interface and an "approved Access application in my case". I would just like to try this first. So how can i move from the first record on my form to...

Hello dear people of Access world! I have a question concerning passing data from a form with Sendkeys and looping until the last record. - So i have a table with measurements and weights. - I have a form based on this table with all the records. - Access will open a program that we use and...

Hi Mark, Its not from a table. The query takes the date from the form field. Date: ([Forms]![stats_form]![startdate])

Hey Gasman! Thanks again. Well, it displays it right in excel. It looks like a date. But when i check the format it's "general". The query that is being exported, takes the date from a form field. In the query i formatted the field as dd/mm/yyyy But it does not seem to export as a date format...

Hi Gizmo. Just fixed it :) Thanks alot for mentioning it. I just switched them around and use the command button with a transparant background. Should have known better. Cheers

Hi guys! I got a little issue with exporting. When i export to an xls file, and one of the fields is a date field, excel will not format this as a date field. Any ideas why or how i can solve it? Help is much appriciated. Stuck here. Sub XferData2XL() DoCmd.SetWarnings False Dim sFile...

Hi Uncle, thanks for the reply. Yes i do have. This has to do with an image i wanted to put over the button. I am totally aware its there. Yet, i didnt see this as problem. Is there a way around it?

Hi guys! I have a silly issue i can't seem to find a solution for anywhere. Maybe because im using the wrong terms... So i have a continuous form with records. Theres a button on there that does some stuff on after update. PROBLEM: Before i can use the button, i have to click the area...

Thanks JHB :). But didn't work. Same error. First time it works, second time i get the error (unless i quit access and restart)

Alright guys :). Well, i implemented it, but the end user is having difficulty filling up the excel file with data from the past. Having the same problem after 1 time use of the code (button). When Excel is close and the application restarted, it works most of the time. Not always even. Im...

Aaah i understand. Ofcourse! Thank you for sticking it out. Cheers!

Hi Minty :) Thanks. Well, that ALMOST worked. The data is really not correct. I have 1 duplicate, so i should end up with 12 records instead of 13. But i end up with 8??? Also when i count the pallets and the boxes, its 100 pieces off.

Thanks minty, There lies a problem. If i sum the checklistID field it just adds up all the numbers.

Hi guys! I have a little question concerning my query. I have a column (checklistID) with values i want to be unique (because im counting this in another query). But i also want the boxes and pallets to add up (sum). So in the example, my result should be: PALLETS: 0 (empty) BOXES: 28...

Ok little edit. It DOES seem to work when i wait for it, close the Access application and open it again and retry. Closing the form alone and reopening it doesn't work. Quiting Access does. Which is sufficient enough for me :). Not pretty, but its ok. Again everyone, a million thanks. Really...

Wauw! That worked instantly. However, when i run it a second time, it says the file already exists. When i overwrite it, it seems to not have changed from the previous time. But the parameter stuff is solved. AWESOME!

Understood :). Thanks Gasman. I still get the parameter error in the below full code. When i debug it highlights the following line: Set rst = rst1.OpenRecordset Sub XferData2XL() DoCmd.SetWarnings False Dim sFile As String Dim xl As Excel.Application Dim rst As dao.Recordset, rst1 As...

Thanks again :). Not defined strSQL = Still having that issue. I have to set the path again?