Search results

Hi Guys I am trying to create columns in a table using VBA. The names of the columns will come from a query that extracts the Column Name from another table. Psuedo Code: input = input.txt -> Select ColumnName from TableA Where TableA.TableName = input -> Feed records into a recordset ->...

Hi guys Could some one please help me with coming up for VB code that can check if there are any linked databases, if there is a linked database, it will go ahead and unlink it i.e delete the tables. Thanx guys.

Hi Guys I was just wondering what would be the code to unlink all linked tables in an Access Database. Could someone please help Thanx in advance

Hi guys why would a query with multiple criterias pull together with an OR operator failed to return any results which meet any of the creteria conditions> SELECT First(tblProjectDetails.ProjectDetailId) AS FirstOfProjectDetailId, tblProjectDetails.CommittedCosts...

Hi all I'm just having a problem with a select query that is not returning all the results that match the join conditions for two tables. The results that are missing when one condition ie field has not value in both table though the other 2 conditions match. Is this the way access behaves...

Hi guys I am trying to get my append query to write one record at a time into one table from a join of two other tables. I need to do this because I need to increment a value from the what was inserted in the previous record. I cannot use an autogenerate number becuase we are not allowed to...

Hi Guys how can I use these checkbox to determine what fields to update from this table. ie I want to write a control statement that will update a certain field if the checkbox is checked and not update that field if its not. I have four fields that can be updated in any combination according...

Hi Guys I'm having some trouble using checkboxes. I want the user to be able to select which columns they want updated for each record by selecting the appropriate check boxes and clicking save. I have created the form but the problem that I'm getting is that if I check a checkbox on one...

I want to create a query that will add the values from two rows. The two rows have two attributes that are the same The table is as follows ID InvNumber ItemNumber PaymentNo Amount 1 W123 1 1 100 1 W123 2 1 100 I want to add the amounts and the selection criteria to be based on the InvNumber...

Hi guys I'm using the query wizard in access and I'm running the queries using DoCmd.OpenQuery and I was wondering if is possible to use transactions with such queries Cheers in advance

Hi Guys I'm trying to import date from an excel worth sheet into Access but nothing is inserted into the column. The format of the date in excel is 20090128 which is American format and I have also confirmed that the Access uses this to handle dates etc. That data type(in the Access) table...

Hi I've been trying to create an open file dialog box and I can't get it to pop up. Is there a module I need to create and if so how do I do it. I'm able to import the file using the transferspreadsheet command but I want the user to be able to browse the filesystem and select the file...

Hi I was wondering if someone could assist me in creating a query that will select a row with the highest amount(money) amount duplicate records. This is how it is structured: 1. I have a BatchNumber, ItemNumber and Amount, 2. An item is identified by a combination of the first two columns...