Search results

I have an wakward little problem. I have a tableand it has entries under the title of Totals. Each total is entered under a number eg 1, 2, 3. There will be either three of four entries for each total. Eg Total1 may have 3 entries and Total2 may have four entries. Is it possible to seperate...

Is it possible to record what web sites that is vistied by a user and have what addresses they visited recorded in a database?

Im sorry about this i know this is a word question but im stuck. Is there a way to open up a Global Template Everytime a template document is opened? I know it can be done by placing the file in the startup folder but i only need it to be opened for the single template. Thanks

On a text box on a userform is there any way to restrict the user to enteronly numerical values and possibly a . (decimal) using VBA?

thanks for that. Does I now have a date search for the full date (dd/MM/YYYY) is there anyway way to maipulte the search to search for MM/YYYY even if the data is stored in the database as DD/MM/YYYY

thanks for the replies. Could someone please expand on the strSQL format Date part please. Im not too sure what this means.

I have this line of code that is part of a search function. It searches dates in the database Set rst = Db.OpenRecordset("SELECT * FROM tblESTIMATE WHERE tblEstimate.DATE='#" & txtDate & "'#") whene the ode is run i get a syntax error telling me that i have a syntax errror in the query...

is this what your after? Set rst = Db.OpenRecordset("SELECT * FROM tblESTIMATE WHERE tblEstimate.DATE='" & txtDate & "'")

I have a problem searching dates. I have created a proceedure in excel to search a database using a date inputted by the user. I can carry out a search using the format(DD/MM/YYYY) however i cannot get the seach to carryout the search format(MM/YYYY). I think the problem is down to the way...

i have a list bo that displays unique information taken from a database. How is it possible to display the information in alphabetical or Numerical ordeer

could you explain this in more detail please. I didnt quite get what you meant.

I thought i needed to put the code in to the recordset to get the data from the database. How else would i populate a combo box using data from a database?

i have this line of code but am getting a syntax error Set rst = Db.OpenRecordset "SELECT [tblESTIMATE].[IWO] FROM [tblESTIMATE ] GROUP BY [tblESTIMATE].[IWO] ORDER BY [tblESTIMATE ].[IWO]" it is exactly what you said as far as i can see. am using this in the right way? If i put () in the...

do i need to do anything with the code? Do the brackets need to be there? or should i use the code as i was before ie: ("SLELECT * From tblEstimate WHERE IWO")

I have a line of code in vba which searches a database and collects a information. The info that it collects is then put in to a combo box. Is there anyway of getting the combo box to display only unique values (ie not repeat data) the query in the code is currently ("SELECT * FROM...

Im not too sure about XP but we have Office 2000 running on windows 95, 98, 2000, and NT machines without any problems

Doe anybody know of a way to add tooltips to custom button using visual basic?

A combo box might be too small for what i need. The database is to hold thousands of entris eventually. What i have works fine its just that when the wrong code is entered i would like to give the user the option to reenter the code and not have to click the command button again to call up the...

this is probably stupidly simple to answer but i have function in which requires the user to enter a number. The number is then used to retireve data from access. I have a check to see if the data entered is correct. this works fine but from the point that the message box alterts the user of...

Ok youve got me thinking now with the Bob thing. If i wanted to put a an if statement to check the valididty if the weight entered in to the strFileName would this code be suitable If strFileName = tblESTIMATE.Weight Then MsgBox "The Data entered is Taken From IWO Number" _...