Search results

Thanks Cliff I stumbled upon that too and was about to update this thread with that when I saw your reply. I added in that reference and now it works perfectly.

I have the following code in Excel VBA. The OpenQuery part of the code is working but the Transfer Spreadsheet part isn't giving warning runtime error 3170 Could not find installable ISAM Any ideas? Set A = CreateObject("Access.Application") A.Visible = False A.OpenCurrentDatabase...

I have data in a table in Access. I need to show this data in a summary document but keep getting a circular reference. Is there a way I can do this, using just one query, without creating a circular reference? See example in Excel. My data in the the Main Info Tab. I have Weeks, Qty, and an...

I've attached my database to the thread

Now attached my database. Also a picture, from Excel, of what I am trying to achieve

I have tried update queries, make table queries, etc, but each time I either get a circular reference or a destination table is the same as source table error. I have tried to attach my database in a ZIP file but not sure it has worked because I keep getting logged out. Query qry_DEPARTMENT...

Hi Not sure if this has been asked before, wouldn't know how to begin looking for it to be honest as I am going to find it hard to describe. Basically we have stocks of an item and we monitor stocks coming in and orders going out week on week. We have an opening stock, we then add on...

Thanks After some playing about I just got that exact same solution. Thank you

Apologies if this has been asked before, but I couldn't find anything. I have a form with quite a few fields on it. What I want to do is have a ComboBox which holds a list of all the field names. I want the user to be able to pick a field from the list and the form sets focus to the field they...

I have an access database which exports data out to an excel file. it then formats the excel file and adds in pictures. What I want to do now is add a hyperlink to the picture. I have recorded a macro in excel of me doing this and I am trying to copy it into access but I am getting a message...

I have a form in an access database. On this form are options for the user to select so thay can run there own queries. What i now want to do is give the user an option to save the results down. Quite easy if they are being saved in the same place. i.e. C:/Temp, as every user has this file on...

I have a macro that runs when a value is changed in a cell. But it moves me to Cell A1 once run and I have to click back to where I was, i.e. line 200. Is there a way to get the macro to run but then to take me back to the cell I was in? Code at the moment is just Private Sub...

Thanks Dave I changed it to this but I get a Data type mismatch error If 5 = DLookup("TabNo", "Running", "[TabNo] = 5") Then I want to look for 5 in the TabNo field of the Running table. Then if there is a 5 in there run one macro, if there isn't then run the other macro

I have a D Lookup, which works, if what I am looking up is in the first row, for some reason it won't go beyond. Can anyone help. My code is If 5 = DLookup("TabNo", "Running", 5) Then DoCmd.RunMacro "Macro1" Else DoCmd.RunMacro "Start Table Macro" End If No it will look up 5 if 5 is in...

Hi Have this code Private Sub Command2_Click() If Me.Text0.Value = DLookup("TableNumber", "RunningTables", _ "[TableNumberID]=" & Me.Text01.Value) Then Me.Text1.Value = "yes" Else Me.Text1.Value = "no" End If End Sub But I keep getting Runtime error 2001 you cancelled the previous...

I have a table with a start time in it. I have a query that relates to the table. In my query I have a duration field Duration: Format(Now()-[Start Time],"hh:mm:ss") this gives me the length of time thats elapsed from the start time to now. I now need to convert that into Minutes elapsed. I...

apologies for the lack explanation, but you did manage to answer it. I picked up the reference in excel and replaced it in access and it worked perfectly xlPasteValues = -4163 xlNone = -4142 Thanks for your help

I have the following code which isn't working, can someone help? xlApp.Range("D14").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Basically I am formatting an excel spreadsheet from Access then resaving as a different name.

Thanks for the reply, I don't think I explained it well. I have a table with, for example, 5 peoples names in it. I also have another table with orders these people have placed in, lets say, 3 months. What I want to to is run the one query 5 times, i.e. for each person in the table to show...

I have an access database. It has 2 tables, One with a list of peoples names and one with a list of orders. I have one query. I want to be able to run this query for each person in the first table and export the data as that persons name. THen move onto the next, and so on Is there a way I can...