Search results

I have a form with subform, containing data from 2 tables on a 1 to many relationship. I would like to append the data in the form and subform to 2 seperate tables. The destination tables each have primary keys, (autonumbers) along with the fields I wish to append from the original tables. Can...

I have a form with subform, containing data from 2 tables on a 1 to many relationship. I would like to append the data in the form and subform to 2 seperate tables. The destination tables each have primary keys, (autonumbers) along with the fields I wish to append from the original tables. Can...

Thanks Your right Wayne its not worth it. I have read through some similar posts and using information from there I will just sete the forms Data Entry property to True. Thanks anyway

Is it possible, in a continuous form, to have the blank record, (next available record), to appear at the top of the records when opening the form.

Sorted The form is based directly on a table Missinglinq. But thanks info from another site it appears to be working now, Solution:- Enabled = True Locked = True for all the fields .

I have a button that when clicked on the form allows the user to type a surname and searc the database. however at present the full surname must be typed correctly. I would like for it to be able to search with only part of the surname being entered. How could I change the following code to...

I have a form with all fields enabled option set to No. The user must be allowed to click a delete button to delete a record but cannot edit or add records. Is it possible to prevent the fields from greying out in this situation. I have tried by enabling the fields and instead setting the forms...

I have a button on a form with the following code on click. This sorts the records in Ascending order. How would I modify the code to sort in Descending order. Private Sub SortName_Click() On Error GoTo Err_SortNameBtn_Click 'Sorts the records by Surname in Ascending order Me.OrderBy =...

Thanks Bob Thanks. Perfect

I have tried to find the solution to this on the Internet but cannot find anything to help. I have a date field showing on a form. When a users enters a date I want another field to automatically display the day, i.e Mon, Tues etc. Is this possible?

Thanks Rich I never thought of it that way. I have deleted the Age field and taken your advice. thanks

Is it posible to perform calculations within a table or data entry form. I have a date of birth field and an age field. I have an Update Action Query that automatically works out the date, (See below). However if I design the form with a close form event that triggers the query I get the...

Thanks Thanks Guss. I had to change your semi-colons to commas, (as below), but worked beautifully after that. thanks for taking the time. Left([Forename],iif(InStr([Forename]," ")=0,Len([Forename]),InStr([Forename]," ")))

I am having a bit of a problem with my update query. i have a field that shows a forename. i am importing data from an excel file. The forename populates with forename and middle names and they are seperated by spaces as opposed to commas. I have used the following InStr function in my update...

Yes I have tried that but it still returns same value. Thanks anyway

I have a form that has a check box, (Attended), ticked if a condition is true. I have placed a text box on the form to count the ticks. I have tried various expressions in the control for the text box but it continues to count the all check boxes whether ticked or not. I tried something like the...

thank you, works perfect

Thanks you Thank you. Works perfect.

I have a command button on a form, (PrisonersBySurname), that has the following code attached which opens a new form, (Prisoner_Details). would like to add code that closes the original form when the new form opens. Any ideas? Private Sub OpenPrisonerDetailsBtn_Click() On Error GoTo...

Firstly is it possible to open 2 forms by clicking one button on another form. Secondly is it possible to open the 2 forms so they do not maximise and instead sit side by side to be viewed at the same time. I use a macro on the OnLoad event of the parent from to maximise it when it opens.