Search results

Hi, On my form i have several listboxes. When i want to delete a record which has no related records, it will delete. But if there is a related record in the database the row will not delete. How do i go about showing an error message to say the selected row cannot be deleted? thanks

Hi, i am having a problem with the statement below. StrSQL = "DELETE * FROM tbltreatment WHERE treatmentid=" _ & Me.lstthreading.Value & ";" CurrentDb.Execute StrSQL The error message i get is syntax error(missing operator) in query expression 'treatmentdid='. any help is much appreciated

I have a bound form with an autonumber field for booking ID. Is there a way for the autonumber to generate once the save button is selected, rather than the autonumber being generated once the form loads?

I have a listbox with details of items and prices, how do i go about calculating all the prices within the listbox?

I have several listboxs on my form , How do i delete the row i select?

I have a form which shows available times for a booking. When i double click on a time , the main booking form opens but the details selected does not transfer to the booking form. Is there a particular way of doing this? at the moment i am using the [forms]![form-name]![fieldname] method.

I have a query to show availability of a booking. When i run the query, it works fine. On my form i am trying to create a listbox using the same query. But when the listbox wizard shows the result , all the fields appear as #name?. how do i get it to show the query data instead.

When i click on a field in my booking form. A pencil record selector shows on the left hand side. When this is there i cant do anything with my form. Is there a way to remove this?

I have a main form which holds details of treatments. These are in list boxes. I have an add button which opens up another form to add a new treatment. However when i close the add form, i would like the data to update on the main treatment form as well. At the moment it only refreshes after i...

Hi, I have 4 rows in my table but my form only shows the first record. How do i allow the form to show each record?

Hi, How do i delete a selected row from a list box? My listbox has the rowsource type of table/query. When i try to delete the selected row all the data is removed and shows the query that was used to populate the listbox details instead

Hi, I have got a few textbox fields and a listbox on an add form . the values in the textfields are transferring to the correct textbox field on the main form but the data in the listbox doesnt save or appear on the mainform listbox. any ideas on how to transfer the data frm the addform...

I am able to add values in a text box to my listbox. However when i try to add a second row of values from the text box. It replaces the first set of values i put it....How do i stop the listbox from doing this .....

On my main form i have a text field and a combo box.I want the values in both the boxes to show in the list box wen the add button is selected. How do i go about doing this. So far only the values in text box field updates to the list box but the value i select from the combo box doesnt show up

Hi, I am having trouble linking the subform to my main form. Both the main form and subform are unbound. When the form loads all the details show on the main form but it doesnt link with the subform. Is there a way to link the subform with the main form without making the subform a bound form?