Search results

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

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?

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

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

I am using the Calender 7 function. I want it to be invisble when the mouse is not over it? Cheers

I have small problem that I can't get access to edit my own database because the are constantly people using it. So is it possible to kick uses off my database so that I get exclusive to edit it? Cheers

Has anyone tried to build GIS for access or VB that I would be able to use?

How do you open a second access database? Without using a hpyerlink.

Is it possible to open a second access database, other than using the hyperlink methods? Thanks

Hi, How do you change to a new line in the body text? Because I want to have a simple table output.

Can someone please time me want is wrong with is code. I am trying to send a email for each person in a table called Tbl_Uses. I am new to using data connections so is there something basic at the start which is need to do? Function email() Dim Report As String Dim emailaddress As String Dim...

Can you use the LIMIT function in access? It limits the number of records out putted by a query. Cheers

Hi, I am new to access web program. Can use PHP. I would like to be able to filter records by the use of the URL ($_GET php function) is this possible in access. Cheer

I am trying to uses a inputbox. I need it to end the script if cancel is hit, but the value from the input box can be zero? So cant filter it that way. Also Does the SQL command LIMIT work in access and is it possible to number row in order?

When you click Ok on the msgbox i what it to repeat the process that it has just done. Private Sub Form_Current() Dim WholeSpec As String Dim Filefolder As String Dim Filename As String Dim s As String Dim i As Integer If IsNull(Me.txtname) Then...