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
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 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
How, when im in add mode, after i finish entering all my inofrmation can i check to see if some other record already exists and not add the record i just yped in.
i am new to this and i just got a database/vb project and up at the top of my form i have a file menu that i want to add a return option to but i dont know how to edit that. any help thanks
skierm
I want to be able to export an access data record to a new document in excell. How do i make the new document in excel and use a template that i made, then specify where the data should go. Is there a tutorial out right now. Thanks
I dont know if this applies here but i would like to know if there is any way that i can figure out the ip address and subnet mask of a person that i had a conversation with on aim. They are harrassing my young cousin and shes scared. I want to you this to locate them and you to report to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.