Search results for query: *

thats what id like to do but dont know the line of code for it. RIght now the code i have in the just prints to the default printer.

Is there a way to when you push a button to ask what printer to print to?

well the data gets entered fine into the flexgrid but the problem is when i click on the square i want to edit, it doesnt give me a cursor. it just stays highlighted

i cant seem to edit the data after my query runs and puts the data into the flexgrid. Any suggestions?

does anyone have any other thoughts

sorry about the repost something happened on my computer, but when i click on the flexgrid i cant even put in data. Its almost like its locked to readonly or something like that. Thanks

Is there a way to edit the data that is loaded into a flexgrid from a query. if not what way should i go about doing it? thanks for any input

Is there a way to edit the data that is loaded into a flexgrid from a query. if not what way should i go about doing it? thanks for any input

I have added a find button for my form and i want default settings to be look in: my form name match: any part of field search: all is there any way to do this by just code

i am getting this error. Syntax error (missing operator) in query expression '(FName=Nancy)'. any thoughts

when i press a preview report button i want to be able to just view the report of the record i am looking at now, and not all of them. How can i make this button do this. thanks

i want to use a msgbox that has yes or no option and then depending on what the user chooses i want to do something. i just dont know how to get the values from the function msgbox. thanks

i also have a question about msgbox if im using yesno format how do i access the answers do i set something=msgbox..... or what thanks

thank you very much

basically im calling this line excel_sheet.saveas "C:\data\file.xls" and if that file exist i want it to prompt for a new file name. thanks

How can i check to see if a file exists before saving and then if it does to ask to change the name of the file your are saving.

thank you it work great

i am trying to get "select * from Item where ItemNumber = " & num1 Item is a table and itemnumber is a column. i want to geteverything that has the same item number then take another value from it when i get the info. But, im getting this error No value given for one or more...

here is my code Public Sub ChangeInventory() Dim cmd as ADODB.Command Dim rs as ADODB.Recordset set cmd = New ADODB.command cmd.ActiveConnection = cnn cmd.CommandText = "select * from edition where edition = " & num2 cmd.CommandType = adCmdText set rs = cmd.execute if (rs.eof) then...

are there ways to search a database using two fields. FOr example i want to search the database for an entry in table EditionNumber where the parameters match a specific edition number and also an item number from that same table