Search results

i've just managed to do it, and now i've done it its really quite simple isnt it? i was messign around trying to change things that are tottally unrelated. Thanks for all your help in getting me there.

Hey thanks for not giving up on me just yet. And sorry for not reading properly. Was there meant to be an attachment to that last post of yours ansentry?

thanks very much for your help so far and i've now downloaded and had a little look at the northwinds sample data base, first thing i can say is :P very complex. but i think i get some parts of it i've been trying again and again to get this part of my database to work and its seriously...

hey ansentry thanks for your help so far. i'm using access 2007 and it doesnt have the northwinds example database. As for your example i can see that the customer details are a combo box that looks up data, but i cant see how it ONLY looks up customer data. Sorry i'm not very experianced with...

Thats just what i was looking for, and i've been able to set that up, however when i'm creating a "new order" i also have to put in employee details and product details etc, when using the method you described, the previous order information is also inserted into the table. I've attached it...

Hey there. I've got an orderform in access, which has employee details on, delivery date, completion date and alot of customer details on, there is also a subform with product details and quantities in but that doesnt matter. I am wondering how i can in someway create a button, or just a...

thanks very much :D

I've got a form that displays all of a customers details, however i wanna be able to search the customers. I have implemented (sort of) a search feature, so you type in the surname, click search, it looks up a query and then u select the result you want and it displays. however, i cant get the...

thanks alot :D all sorted

thanks so much for all your help, works like a charm now :D woo edit: ok i spoke too soon, it works, however, even if the password is wrong, it still logs you in *-) is there anyway of getting around this, i've had a play at moving different parts around, and i can get it to say "invalid...

So therefore my code should look something along the lines of..... Private Sub cmdLogin_Click() If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required Data" Me.cboEmployee.SetFocus Exit Sub End If...

i've had a mess about and tried to add it into the code so now it reads 'Close logon form and open splash screen Dim Struserlevel As String Struserlevel = DLookup("strlevel", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) If (Struserlevel = "Admin") Then...

Hey i'm using the login form from databasedev, and in the tblusers theres a place for either Admin or User, i was wondering what script would have to be included in the login to get Admin's directed to the SwitchboardAdmin and the Users to be directed to SwitchboardUsers. I've attached the file...

thanks for your help i'll have a try at it and let you know how it goes

No i dont know how to do that, i have a number of tables into which data is inputted however i have a schedule as well that displays certain data, i basically wanted to have the DeliveryDate CustomerSurname and CustomerFirstName to be almost like copied from the three cells in one database and...

hey i was just wondering if data entered into one text box with a form when saved can enter itself into two different fields within two different tables? and if so how? i guess it'd probably involve scripting of some sort but i'm a total beginner thanks in advance

Hey thanks for your help so far, i did do some searching, and after finding different explanations and so on, i came across a pre-made calender. I've messed about and adapted it a bit, basically, theres a table with Dates and Information in, pretty straightforward the Information is displayed in...

Thanks for the reply namliam. its good to know it is possible, is there anyone who could point me in the right direction of how to implement something like this? Thanks again

Hey there I'm currently doing an ICT project for some school work, in which we all have to make access databases. My database is based around a fictional company that provide driving lessons. I've set most of the tables up including clients employees, bookings etc, but i'm wondering if its...