Search results

how do i add queries into a form of my switchboard using the manager? what option is it? thanks

in properties of the combobox i have in the after update row it linked to a macro. the macro has the actions gotocontrol and then findrecord. the findrecord, under find what is =[FindIt]. FindIt is the name of my combo box. what im trying to do, is that if the user navigates the records by...

this part of one of my codes Private Sub Form_Current() doesnt work, it says that there is a syntax error in it, what is wrong?!

I have 4 forms and 1 form used as a switchboard. The forms i link to are car, customer, tyre, and invoice. I'd like to create an option group on the switchboard form, so that the user will see all 4 forms listed with an option button next to them. clicking on the option button will make it...

i have 4 tables in my db, customer, car, invoice and tyre. a customer has their car fitted with new tyres, and the db is used to store their car info and tyres fitted and personal details. i can make a form with the car and customer info together so i can enter it all at once fine. but if i want...

i like the new one, nice and simple, but without being boring imo

Oh! so the relationships are ok after all then? I just tried the subform thing, and it does seem to work! Thanks. can you get the subform to look like the rest of the form, or does it have to stay looking like a table on a form? sorry to be so unknowledgable, im a bit of a newbie to access :)

okay, attachment one is a screenshot of my relationships. the database is for a project im doing. customers take their cars to be fitted with new tyres, and charged as applicable depending on the type of the tyre. i have created a autoform from a query 'invoice entry'. this query allows me to...

hi, ive had this excersise to do as ict homework. one of the questions asked me to use the filter by form function to show only all the sailings from portsmouth that are priced between £90 and £130. i have attached a screenshot with the problem on it as i wasnt sure how to explain. ive just got...

im trying to change two of my fields, start time and end time so that they show two decimal places. in design view i changed the properties as shown in the attachment, but it isnt working. what have i done wrong as this should be really simple but i cant fix it!! thanks

i have to produce invoices in a project i am doing for my as in computing. however i really dont understand what to do, i know that invoices are usually produced as reports but i dont have any idea how to do calculations in access??? can anyone give me the basic idea, thank you very much for...

ok thanks anyway :)

I was wondering if it is possible to change the colour of the command buttons, as I don't like them grey. Thanks

okay, I have it working thank you for your help! What would I need to do to stop it closing the switchboard once you press ok?:D

Private Sub Command2_Click() Private Sub MyCommandButton_Click() If MsgBox("Do you want to open this form?", vbQuestion + vbYesNo, "Open Form?") = vbYes Then DoCmd.Close acForm, Me.Name DoCmd.OpenForm "Car" End If End Sub End Sub

Compile Error: Expected End Sub and its highlighted that line :confused:

thanks, i've tried this but i'm not too experienced with code, it is telling me that something is wrong with the following line Private Sub Command2_Click()

I am creating a switchboard for my database from stratch. I wanted to have an option group, which I have created, and the options in it are the names of the forms in my database. I currently have it set up so that when the user clicks the option button, the form is opened immediately. However...