Search results

Well I fiddled about some more. This code locks all the records, somehow I need to add something that will tell it to just lock the records to be locked. Can you spot the mistake?? Thanks Private Sub Form_Current() Dim frmrpahdr As Object Dim rs As Object If Me.Locked = False Then...

I see "On Current" on the event Tab. Maybe an event procedure on that would change Allow edits to "No" when tblData.Locked = false.......But I don't know how to write that in VBA?..well I tried but it does not work..any help appreciated. Private Sub Form_Current() frm = frmRPAhdr If...

I can't seem to find any answers to this maybe i am asking the wrong question, or its so easy nobody asked. I am viewing / editing some records in a form, I want to view all of the records but only allow edits to records with forms with tblData.Locked = false. How do I achieve this. thanks Steve

I have an append query which takes rows from one table and places them in another when a certain criteria is met. When the source table has a qty greater than 1; I need the receiving table to get a record for each qty e.g. Source table: partNumber; qty 123; 3 111; 1 121; 2 Receiving table...

Thank-you very much.

I attached a small example. Its a simple problem but I just don't know how: It has one table, one form and one update query. The form has one combo box based on the table. When I select the Combo field value and press the button I want to run the update query filtered for the selection. Thanks

Bingo - thats it - thanks Steve

Thanks, that writes a SQL, exactly what I wanted. the way you have laid it out i can understand too - that has been part of my trouble. Trying to explain why I need it - I can use query design view and do one offs, but the people who will be using this database know even less than i do and so...

Maybe I am on the wrong road - I changed the statement in the example - I hope it will explain. I need a new statement written each time I press that button. SELECT tblpeople.Name, tblpeople.Skill, tblpeople.Discipline, tblpeople.Level, tblpeople.ID FROM tblpeople WHERE...

Thanks for your help. I have attached a small database to descibe what i am doing. Open the frmMain. There is a text box which shows the SQL statement I am trying to achieve. Well - it is shown for some specific values - I need it to work for the values selected in the combo box. The code for...

Can I change my mind. I dont think either do what I need. I want to set a value in say three combo boxes in a form. Then press a button which will take the values and write a sql statement to filter the sub form. Any example of this? Thanks

Can't see it?

Thanks - it did not quite do what I wanted - I found the link below in case anyone else is looking - to a similar example which I can use, I think. http://www.candace-tripp.com/_pages...s_downloads.asp Steve

Here is an example of what I am trying to do: I have a main form which has 4 combo boxes all based on tblPeople. Combo0 is skill Combo1 is discipline Combo2 is crart Comb03 is active The sub form is a datatable list of the tblpeople. How do I apply the filter to the datatable. I am assuming...

In Northwornd there is a macro called "Customer labels dialog". It disables the Select Country Combo Box if the "All Country" radio button is True. I can't see what starts this macro - where is it called to run? Thanks Steve

That worked fine. Just run the email query, filtered for [readyforupload] and then run the next update query to delete the [ReadyForUpload] flag and insert a date. Thanks, Steve

I have a query that selects all records from tblAFP that have [ReadyforUpload] = true. A macro runs that query and outputs that list in a spreadsheet attached to an email. This part works fine. However I would like to insert date in [RecordSentDate] in the tblAFP table, once the email is...

that works, Thanks

See the attached. I don't know if it works for you. Look at the query.

I have uploaded a tiny database which illustrates the question. I have a series of welds, in the example there are 6, numbered 1 - 6. I want a report which only shows the first and last weld details. I made two queries, one with MinofWeldNo and one of MaxOfWeldNo. Then a Union query to bring the...