Search results

any other suggestions please

thank you very much for the suggestion, it makes sence and i will consider it thank you would love to hear if anyone else has another idea?? THanks again for the great reply MS AcessRoocki

i Guys I really need som advice about an issue i am facing in my database.. I am buildning a database where the user would be able to enter a value in one of the text boxes, the value will range between a max of (100) and a min of (<5), ie the enteries in this field could be 100, 55, 64, 24, etc...

thanks man¨ really appreciate your answer

Hi guys is there a simple way to update the value of a specific record in a table so that the new value is the old value +1? let us say i have a table1 and i want to update the value of units where the Item column equals Cars i can do this by: Dim oldVal as Integer Dim sqlString as String...

Hi guys Need som help with a thing I am trying to use the DoCmd.RunSQL command and put a string after it like this: sqlString="update [Order Details] set [UnitPrice] = "& var1 & "where OrderID = " & var2 & ";" DoCmd.RunSQL sqlString My problem is the following: as you know there has to be a...

THank you so much for the reply, really appreciate it

HI All I need help with something that i have been looking for for days now If i want to look up a vlaue in a table then i use the Dlookup Ex DLookup("[UnitPrice]", "Order Details", "OrderID = 10248") In this example, you would be retrieving the UnitPrice field from the Order Details table...

Can anyone helph please with the VBA code ??

Thank you for your answer not really, i have nt disabled it.... I am a rather new beginner to acces,s i would appreciate if you could help me with the code for that please??

Hi Guys I have attached with this post a logg in Access form that i found in this wonderful site which can be used as user name / passord control authentication before accessing a database Now i need your wonderful help to creat a button in the switchboard that opens another form which allows...

Thank you all for very valuable replies However the problem is not solved by the code above, it might be a good idea to look at the database i attached The thing is that the data entered into the text box is linked to a "control source" ie a column in a table that only accepts numeric data...

Hi All Need some help with error traping I have attached a file that illustrates the problem The user enters 2 values a name (text ) and a number (number) If the user enters a text in stead of number in the number text field, access protests with a text box I have been trying to trap the error...

Really appreciate your help7 Could you please help me with the VBA code?? I attached a similar design form to my problem I would really appreciate if you could take the time to help wth the code Thanks again

Thank you so much for the quick respons Let us say that i instead use three columns in my database to store the selected items (three items in the list box, three columns in DB, one for each item setting a value or check box if item selected in list box) what would the appropriate aproach be...

Hi Guys I have created a database in which the user has an input form, one of the controles used in the form is a list box allowing multiple selection (Multiselect propery = simple) I have 3 items in the box and the form is linked to a table My question is the following: Is there a way to store...

Hi All again I found the solution to problems 1 and three, took some time with VBA Could anyone please give me a solution to problem 2 ie a way to make all the background MS Access windows dissapear, ie only the search form is displayed, as if it is a stand alone application, can it be done??

Hi Guys Thank you so much for this wonderful site I need som help modifying a database search that was posted in this site for free use The database is attached with this thread. I need help with a couple of things: 1- In the search forum (frmSearch), i need to add another buttom that simply...

autofill column with data Hi Guys Please help me with this issue I am a begginer in access..I have created a form that inputs the Birthdate of a contact into one column in a table, the birth date is input as (YYYYMMDD), I wan a way in access to autofill another column in the same table with...

Hi Guys Please help me with this issue I am a begginer in access..I have created a form that inputs the Birthdate of a contact into one column in a table, the birth date is input as (YYYYMMDD), I wan a way in access to autofill another column in the same table with the age (as years intiger)...