Search results

Hi, I`m having an issue. I`m writing VBA code behind a form that used SQL SELECTS on various tables - the results of one query determine the next. I`m using the ADODB object library: strSQL = "SELECT * FROM Table1 WHERE Field1 LIKE " & value1 objRecordSet.Open (strSQL) Then later...

Hi, I am trying to create a new form from an existing table and I'm seeing something strange. I click on the Table name, then create the form using the 1st icon (the one labelled Form) - it creates a new form, but for a different table. The recordsource of the form itself is the right one...

Hi, I have several tables that are linked that I need to be able to add to. This is an example of the structure: Patient Info ID FK_Ward – ID of Ward table FK_Room – ID of Room table FK_Cond – ID of Condition table Ward ID WardID Room ID RoomNumber Condition...

Hi! I apologize in advance for being somewhat vague about the contents of the database - security requirements where I am dictate it! I have a database with a bunch of related tables. One holds information on (let's say) types of food. A field in that table tells whether the food is HOT or...

I am not an Access guru - but have been asked to build a database for us. I've created the tables and a first query, but now I am stuck on how to get all the data into the tables. Basically, there is one table that uses references into other tables for static data. I'd like to create a form...

Hi, I have an issue with a BeforeUpdate procedure that I am trying to get working. I'm using simple elements here as this is a test DB, not the real one yet. I'm trying to get the value from a Text Box TextData into a string cString. I've used a Dim statement to declare cString - I think the...

Hi! I am a jack-of-all-trades currently working in MS Access. I don't have too much Access-specific experience or knowledge, but I have been using SQL Databases for a while so I understand how they work - just getting the nuances of Access working for me is what I am trying to do. Thanks in...