Recent content by snypa

Oh, I'll try that, will it import the structure from an excel sheet dump though? Thanx

Thanx for thr reply I'm trying to recreate a database from an Excel dump of a database. So I have the table names and the columns for each of these tables. So I imported this list into a table and I would like to use the records I have in this table to recreate the database from the excel...

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.

I want the users to be able to link and unlink tables at will because the databases they are linking to are change every week. These users aren't that tech savvy so if they press the unlink button and the link manager table pops up they'll have a heart attack so it would be ideal for them to...

I'm developing in Access 2007 for use in 2003, I'll give that a shot but the users might get confused when they see the link table manager

Thanx for the response, I thought of that but It'll have write the names of all the tables which is a bit tedious, Is there are way I can delete/unlink all the linked tables. mayby create a loop that lists all the names of the tables

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

Yes but will that affect the results or the sorting?

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...

SELECT tblSuccessfullIncurreds2.Group, tblSuccessfullIncurreds2.PONumber, tblSuccessfullIncurreds2.ItemNumber, tblSuccessfullIncurreds2.CMSFacility, tblSuccessfullIncurreds2.CMSCommodity, tblSuccessfullIncurreds2.CARNumber, tblSuccessfullIncurreds2.IncurredCosts...

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...

Do I need any modules for this to work coz I've been looking at it for a while and I want to put the code under a button. Do you have an example I can look at

can I use conditions and use the following logic 1. initiate the variable = x DO 2. check if record2 field = record1 field 3. if true variable = x+1 Loop

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...