Search results

Hi, all. I can't seem to iron out this query.. Here are the important table elements. Key DeptGroup truckCount IA702 Facilities 5 IP000 Plant 1 2 IP001 Plant 1 2 etc.... What I'm needing to do is Wherever...

Thanks Very helpful information. My understanding of the internal workings of Access is now more complete. Thank you all so much. PB

Hi, This is Excel VBA..... I've got a variable that I want to be able to access from other subs (it's in a sub) so I declared it Public. It crashes at the declaration saying: invalid attribute in sub or function Do I need to set an attribute or function in Excel to allow Public decs? Thanks...

Hi, I'm running this query and it's coming back sorted and I was wondering if there was an option to just display them in table order? SELECT DISTINCT ([Department Info].[DeptGroup]) AS Dept INTO DeptGroups FROM [Department Info]; Thanks PB

Hey all, I can't dig up the syntax for a function that will return the length of an array. Should be an easy one. Thanks PB

Alright! Thanks for all of the feedback. A query of a query sounds like something I need to look in to for another project I've got brewing. The database is not shared thankfully so I can create and destroy any tables I choose. That's helpful. I will note the creation of tables being...

Yeah My boss wants me to generate Excel Graphs that will be querying from the query and I just thought that a query into a table would be more simple than a query into a query. Man, that's a tongue twister almost. Thanks a bundle. PB

Hi all, sorry about the cross posts before... Can I save the results of a query as a table that will show up in my Tables list? Should be able to but don't know the keywords very well. Thank all. PB

Yes Yes, that fixed the CurrentDb() function now it crashes at the line indicated below Dim dbs As DAO.Database Dim tdf As TableDef Set dbs = CurrentDb() Set tdf = dbs.TableDefs("Ark") tdf.Fields("DeptCode").Name = "Po_No" <------------- fails Set tdf = Nothing Set dbs = Nothing The error...

Checked? Well, being the newby I am, I don't know if I have it checked because I don't know where to look to find out. Sorry to be so green in the presence of all you pros. PB

I see Noted for future reference. Thank you for the heads up.

user defined type not defined It won't compile. I get this error user defined type not defined. and the debugger stops here. Dim dbs As DAO.Database Any clues? PB

Hi all, Is there an SQL statement that will change the column name of an existing table??? Thanks . PB

Hi, Is there an SQL statement to change the names of the columns in an existing table.??? Thanks all PB

I have 2 tables One with these columns DeptCode, TruckN, PMC, RepNormC, RepABNormC, SFDPC First, I need to merge RepNormC and SFDPC leaving only RepNormC. They are both currency fields and I need to add them together. The other table has columns PO_NO, FLEET_NO, PM_AMOUNT, NORMAL_AMOUNT...

Hey all, I've got a form with a couple of comboboxes on it. In ComboBox_change() I call a function to do processing depending on the choice from the comboBox. The problem is, it autoruns when the workbook is opened and calls the function with an empty parameter because it hasn't been...

Hey all, I've got a form with a couple of comboboxes on it. In ComboBox_change() I call a function to do processing depending on the choice from the comboBox. The problem is, it autoruns when the workbook is opened and calls the function with an empty parameter because it hasn't been...

Hrmph It worked and I didn't change anything. Thanks a million PB

Wha??? I don't get it. Well, I tried but this didn't work SELECT * FROM Ark LEFT JOIN DepartmentTransitionTable ON Ark.DeptName = DepartmentTransitionTable.OldCode; It keeps asking me for Ark.DeptName and the whole column turns out to be one value. Any clues for me???? PB

Hi all, I've got an update query that looks like this so far UPDATE Ark SET Ark.DeptCode = 'IA702' WHERE (((Ark.DeptCode)='Assy1')); The question: I have 30 different DeptCodes to update. Can this be combined into one giant update query or do I need to write 30 different ones? Each...