Search results

Afternoon I am trying to denormalise a child table in a query for a specific task so that all child lines show on one line but the fields are not concatenated. Table1 - Parent PID Desc 1 Danny 2 Jonny 3 Andy Table2 - Child ID CID PID Destination 1...

Howzit I have a problem trying to add an Addin to an Addin ribbon, but the code will not remove the existing button first - so I end up with multiple buttons on the ribbon doing the same thing. I therefore have to manually delete these buttons. This is the code I have in the "ThisWorkbook"...

Howzit I have recently upgraded to MS Office Professional which includes Access 2010 and find that the application keeps crashing. I use Windows 7 Professional (64 Bit), i7 processor and 8GB ram. It initially crashed when I was playing around in a 2003 format database. Thinking there was...

Howzit I would like to count the unique values in a column based on criteria in other columns. I would like to do this in an array formula or other formula as opposed to vba if possible. In the attached file, I want to: Count the unique PKU values in column B in a 12 month period based on...

Howzit I am having trouble with exporting data from a table to a pipe delimited txt file. When I use the following code, I get a merging of the 17th \ 18th record. The data in the table looks ok. I have used different datasets when exporting but always the same result. DoCmd.TransferText...

Hi All This is my first real attempt at a trigger. What I am attempting to do is remove a carriage return that is included in one of the fields that is uploaded into SQL Server 2005. This syntax plays havoc with a process later on in the process - so I want to remove this immediately. We are...

Howzit Has anyone come across this bug when using Lebans Navigaton Buttons? The frmNavButtons is embedded into another form as a subform. You are on the first record, and you click on the "Add New" navigation Button. This creates a new record, but when you try and navigate away from the new...

Hi We are implementing a new Billing system, with part of the process being cleansing our existing contracts. This cleansing is done on our Live system. Every two weeks or so, I restore the Development Box (also SQL Server 2005) with a copy of Dev. Prior to the restore the user access to...

Howzit I have downloaded a number of sample databases over the past few months, and notice that some of the downloads are executable files (*.exe file extension), taht extract the db into a specified location. Can anyone point me in the right direction as to how and what program could be used...

Hi I am using Access 2003 and trying to add some data to a SQL Server 2005 table. I have linked this using an ODBC link, and can open the table and run select queries on the table. When I try and Append records to it, the table does not show in the table name box. Does anyone know how I can...

Howzit I am trying to convert an update query into vba. This update query includes the use of the DMIN function. The query works, but I can't get the vba method to use. The query is: UPDATE tblSOVStaging SET tblSOVStaging.SOVYear = DMin("[SOVYear]","tblSOV","[AuditNo]='" &...

Hi All We have moved an access backend to SQL Server 2000, and use Access 2k as the front end. When a user tries to delete a line record using the following code DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 we get an error...

We have created a SQL Server back end that will hold all our Billing information that will be required for a new Billing engine. I have created an Access Front end to allow the users to enter the relevant contract information that is required. The realtionships are: tblContAttribHdr (one) [PK]...

I Have been playing around with this now to try and loop through all subfolders (and their subfolders etc) of a directory, looking for csv files, so I can import the filenames into a table. This is the first time I have played around with File Scripting objects. I found mot of this code on...