Search results

multiple email addresses Of course dont forget the condition of multiple email addresses per person : I created the following code, probably not very elegant solution but it works: Centre_Code = Me.CBAuditCode.Value EmailSelectString = "SELECT TblContact.Centre_Code, TblContact.Contact_Method...

I have some sql and have created a recordset. The data needs further refining so question is how do i pass that recordset data to the new second recordset for processing within second recordset sql. re phrase similar to creating a new query in grid and refering to a prvious query. I hope i can...

getobject I have opened the existing spreadsheet with : Dim auditspreadsheet As Object Set auditspreadsheet = GetObject("c:\Audit.xls") The spreadsheet has macros in it and its asking if i want to run them can i turn them off in vba so it doesnt ask? I dont need the excel macros I only want...

docmd.outputto I am not familiar with that method but it doesnt look hopeful as i will need to put the data into certain cells in the template.

I want to export the data from a recordset, create a new spreadsheet from an excel template and then put the recordset data into the spreadsheet and I am not sure how to go about this. advice would be welcome as to the methods available. regards Peter :cool:

I have a database that has student table (I am not a student doing an assessment!) with a one to many relationship to coursebooking and then a course table that has a one to many relationship with the coursebooking table so coursebooking seems to be acting as the link table between the many to...

I have the following code that works in other forms but not this one: Private Sub Form_Open(Cancel As Integer) ' Declare and set a variable to store the WHERE ' clause that describes the records you want to ' display. Dim strCond As String strCond = "STUDENT-DSN =...

found solution I see how it works now. thanks

How do I create a new field in an existing table in vba. regards

next step with table Bob That worked a treat, one other question can I get it to build the table from the reuslts of a query (or recordset) populating the data and just adding the new field (number1) or am i just as wise to use docmd runsql (with an 'into' in the query) regards

The following code doesnt generate an error but neither does it create the table: Dim db As DAO.Database Set db = CurrentDb Dim tdfNew As DAO.TableDef Dim fld As DAO.Field Dim TblDefTemp As DAO.TableDef Set tdfNew = db.CreateTableDef("TblSample") Set fld =...

cracked it I had to save the record before I called the second form which cured the problem, I had thought incorrectly that access saved it automatically but as I wasnt closing the form it wasnt the case. Thanks

I have a form that doesnt close, it gets the basic skeletal details of a booking. I have a button that opens the next form to input the address details and it wont sync. I have a function that checks to see if the first enrolment form is open and the function works fine. it then creates a...

found solution I worked it out for myself with: Me.CBMotherTongue.Value = Me.CBCountry.Column(2) Thanks anyway for looking

I have a combo that uses a query to show countries and the related mother tongue ref if in another column. I want an after update after selection of the country that will select the appropriate language in another combo. The second combo uses a query to look up the list of languages available...

tabs this was done previously (not by me) but they leave the data inputter a little disoriented I was hoping to use a combination of forms and vba to make a seamless transition to the data groups :(

I have an input form that has many fields, how do I go about fragmenting the data collection. I thought I might group related data fileds together ie personal details, contact details and have a separate form for each data grouping or one form and make the fields invisible after they are filled...

I have a recordset that I want to add a new field to, in this case to create a random double number against each row in the recordset. can i do this without making a table or do I have to make an action query in vba and then add the field data using the recordset. hope i have explained my self...

I have a query with a calculated (double) field with the following equation: Random Number: Rnd([Person ID]+(Now()*100000-Int(Now()*100000))) the idea being that the random seed is regenerated by utilizing the Person ID as a new seed + the now function. this works and fills the field with...

Big thanks Thank you that will guide me on my way