Search results
-
V
Using TABLE name as textbox value
Thank you for the reply Rabbie. i have tried this Dim strSQL As String strSQL = "SELECT * FROM " & forms!search!table_name.value docmd.runSQL strSql and im getting an error saying " A RunSQL action requires an argument consisting of an SQL statement" -
V
Using TABLE name as textbox value
in VBA or Access design view for a SELECT QUERY is it posiible to specify the TABLE NAME as a variable???? -
V
Using TABLE name as textbox value
Using textbox value as TABLE name Hi guys, im trying to specify the table name in my query through a textbox i.e. the name of table to query from will be specified in the text field. so far i have this: SELECT * FROM forms!search!table_name.value; im getting an error saying 'Microsoft... -
V
Calculating Date Difference
Hi Guys, I have a table called 'Monitors' one of the colums is a date and i want to return values with dates more than 6 months old. i have this so far SELECT * FROM Monitors WHERE DateDiff("m", #Date()#,#Household.date#) > 6; what am i doing wrong here. Thanx in advance -
V
Calculating Date Difference
Hi Guys, I have a table called 'Monitors' one of the colums is a date and i want to return values with dates more than 6 months old. i have this so far SELECT * FROM Monitors WHERE DateDiff("m", #Date()#,#Household.date#) > 6; what am i doing wrong here. Thanx in advance -
V
Single button to close several forms and return to switchboard
Precisely What I Was After Thanx!! -
V
Single button to close several forms and return to switchboard
Hi Guys! Happy belated New Year! I have about 5 forms i use to get data from a user and append to different tables. On reaching the last table i would like to say after the submit button i have another button which when clicked closes all 5 forms and returns to the switchboard form. i dont... -
V
Append Query through Macros
I have many forms and tables and experiencing problems appending the data to the tables as its repeating. In a nutshell say i have these tables: Student_Details, grades and a lookup table courses. Student_Details has a one-to-many relationship with Grades. i.e. in bold are the primary keys... -
V
Append different values to same column
Rabbie I have a table with a field (Cars) the type of cars are stored in a look-up table and contains 5 names of cars. Then i have a form with all the names of the cars and from a dropdown list the user selects the usage of each car (never, daily, weekly, etc). The table i need to update has... -
V
Append different values to same column
Is it possible to append different values to the same column at one go? I have a field that can take 3 different values from a look-up table so there really wont be any duplications is it possible to write all this in a single append query? I am getting an error saying 'duplicate output... -
V
Append query with foreign key
Thanx! i manged to do it by specifying in the CompanyID in the 2nd table as the same from the Companydetails and it worked fine. My problem was not specifyingwhere the CompanyID was comming from. -
V
Append query with foreign key
Hi Guys really having a problem with the key violations i have two tables with a one-many relationship: CompanyDetails - (CompID(autonumber), Address, manager etc) VanUse - (CompID(number), TypeoFVAn, FrequencyUse) note the primary key of the 2nd table is made of all field including... -
V
Append Query for linked tables
Is it possible though to enter 3 records in the second table and 1 in the 1st table at once since its a one-many relationship. That is if one family uses more than one van -
V
Append Query for linked tables
Hi, I need your help i have two tables with a one-many relationship: CompanyDetails - (CompID(automunber), Address, manager etc) VanUse - (CompID(number), TypeoFVAn, FrequencyUse) In the 2nd table all fields make up the primary key i have a form containing all these records and would like...