Search results

Thanks, Heres my final code Private Sub Form_Open(Cancel As Integer) Dim SQL As String Dim rs As DAO.Recordset Dim intLoop As Integer Dim list As String SQL = "Select * FROM Tbl_Adoption" Set rs = CurrentDb.OpenRecordset(SQL) For intLoop = 0 To (rs.Fields.Count - 1) list =...

Sorry I Meant as shown, so that you can pick the title of a field ID Name Address

Hi, How do you display the names of field for a table in a combo box. I know how to do it in mySQL "DESCRIBE employee_data", is there a SQL command in access to do this? thanks Sean

Thanks work when I changed to DAO 3.60 reference. Thanks. Do you know how to input text in to work document? Do you have to put some sort of text box in? Thanks alot Sean

Getting a error on Set Db = line. Works ok from access to access so path must be valid. What reference did you turn on in word? 3.51 or 3.60? Can you post or email me a copy of your example please? Thanks Sean

Change this and still getting the same problem Thanks Sean

Only no how to do DAO connections. I am trying to connect to access from word? Thanks

Hi, I am trying to connect to access database. It keeps on saying that it is a unrecognized format of databae. Code is below Thanks Dim SQL As String Dim Db As DAO.Database Dim rs As DAO.Recordset SQL = "SELECT Tbl_Stage2.Step_ID, * FROM Tbl_Stage2_Step LEFT JOIN Tbl_Stage2 ON...

Is it possible to use VB to create multiply image boxes inside a form? Thanks

Is it possible to list the current Reports open?

Fix it, Square Brakets SELECT TempQuery1.Filter_ID, TempQuery2.Channel, TempQuery2.SpeedBands, TempQuery1.Filter_Channel, TempQuery1.Filter_type FROM [SELECT Tbl_Lookup_Channels.ID AS Channel, Tbl_Lookup_SpeedBand.ID AS SpeedBands FROM Tbl_Lookup_Channels, Tbl_Lookup_SpeedBand]. AS...

Can someone please help with this, it6 is having problem creating number field with 2 Decimal places DoCmd.RunSQL "CREATE TABLE Temp (Speed_Band Text, Site_ID INTEGER, In decimal(10,2), Out decimal(10,2));"

I am try to do all in one queries which has two queries imbedded into. "SELECT Filter_ID, Channel, SpeedBands, Filter_Channel, Filter_type FROM (SELECT [Tbl_Lookup_Channels].[ID] AS Channel, [Tbl_Lookup_SpeedBand].[ID] AS SpeedBand FROM Tbl_Lookup_Channels, Tbl_Lookup_SpeedBand) LEFT JOIN...

Hi Just wondering if you know how to perform a task on load of a new page in side the web browser Thanks Sean

Hi I need to be able to do the following things with the Microsoft Web Browser:- 1. Back page 2. Find what the current pages 3. perform code on load of a new page Help Sean

Have just assiged a date/time field to the record and select the record by this

I am having the same problem? Help Please

Hi, All the computer are on the same windows NT network with login. I want to be able to get the login name of the user? Thanks

Hi, Is it possible to get the user name of the current users window? Cheers Sean

Hi, I have build a database which work perfectly on most computers. But one or two for the computer are error with the Left, Right and Date SQL function. Is it simplely miss for the install or it a problem with my code? Thanks