Search results

Pbaldy, I've used a msgbox to confirm that its pulling back the right data, but then its not running any of the exports or creating the directory.

Hi Gasman, Its not doing anything! Its supposed to create a directory and then run an export. plus my f8 has never done anything, so that'd help if i knew how to fix that too

Hi, Can someone help me. I cant get this code to work! Literally all i want it to do is run different export queries based on what area the person running it is from. Can anyone see where the glaring issues are that are stopping this from running. Dim Holon1 As String Dim Location As String...

Hi Sorry, I think there i havent explaoined right. So both subforms are from the same table. Subform 1 is from a query that displays items that need to be acted upon today. Subform two shows the in depth details of the record, so who what where and notes etc. When i said i tried to link it...

Hi, I've tried the open form, but obviously that opens a new form, not refreshing the other. I've tried to link it through a blank text field but no, nothings working.

Hi, I've attached a pic to hopefully help. So at the top is subform 1 with hyperlinks. When you click it, i want it to refresh sub form 2 (green middle box) using the ID from Subform 1. Do you have an idea on how to do it?

Hi, Im trying to create a form with two sub forms. The first one is a list of activities that need to be done today. This is a series of records with ID numbers. The second is a form showing the details of the record. Can you tell me if the below is possible: 1) You click the hyperlink...

Hi Guys, I have an import statement that doesnt seem to be working I have a table : Tbl_Debt import sheet: import.xlsm import range: Import DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_debt", "R:\In box management project\Media\import.xlsm", True, "import" All the...

Hi Guys, I have a strange issue that I cannot work out. I have an excel import into a table. The table comprises of 5 columns. ID (Which is being imported blank so the table can auto number it. Also the Primary Key), Usercode, CourseID, Progress and Mail. All are number fields and set as...

Hi Guys, I have a query that could have multiple variations as the customer can put in a username as a criteria to produce different variations of the report. I'm trying to get it to export using the Office File Dialog save as using instructions I have found online. I'm doing this as I want...

Hi Plog, I see your point now. That last FY table was added in the default builder as the idea was to add that in, but then i moved to SQL builder. Now I have removed it all works well. I hadn't even noticed that I still had that table on the query!! Its been a long week and as usual, one...

Hi Plog, Hopefully there is an attachement I have mocked up with random data to show what I want. In response to your points, 1) I did have all of the fields as group by, but when i run the query the running query bar can be seen at the bottom, all the way across (basically nearly complete)...

Hi Guys, I have a table which shows all the sales for my company for a year. I want to create a query that sums all of the sales for each user but also shows some other information. This would then return the Top 50 customers. The query I have so far is as follows: SELECT TOP 50...

It didn't give me an error Doc, it looked like it ran but then when i checked it hadn't. Kinda how it looks when you try to run an incomplete If, if you get my meaning.

No idea why Gasman, but that solved it. Working fine now.

Hi Guys, Can someone help please. I have an import command thats not working. The table is a linked table in my back end but that has never mattered in the past. DoCmd.TransferSpreadsheet acImport, , "Tbl_debt", "R:\In box management project\Import.xlsx", yes, "exportrange"

oh i'm more then happy doing the work in excel, just was trying to see if there was any way to do it in Excel. Thanks though

Thanks Sonic, I had seen that but wondered if anyone had found a way to circumvent it.

Hi all, I'm running a simple Transferspreadsheet code to export data to Excel. Is there anyway to only export the data and not the field names? DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "Qry_YTDCFY", "F:\NP Report DB.xlsm", "YTDCFY"

OK, I've gone back and changed the query that runs my drop down to display the info in the right way so I dont have to save it spereately