Search results for query: *

I have a form to view data summaries. Using controls, where the user inputs 'from' and 'to' dates, a query is generated to retrieve data and display it on a subform in datasheet view. The table I'm retrieving data from looks like this: Receivement(ReceivementID(PK,autoinc nr)...

On my form I have two textboxes where the user can enter a 'From' and a 'To' date. A query is then created that returns records between these dates. The result is displayed in a subform, by setting the subforms recordsource to the query like this...

Hi MajP, I have it working now. I found that to hide columns you need to set the .ColumnHidden property to false. Thanks for your help!

Hi MajP, I am trying to hide the controls, but I get runtime error 2165 "You can't hide the control while it has focus". I have this code: Private Sub Form_Load() Dim intI As Integer cmdShow.SetFocus For intI = 0 To 3 With Me.RepQ_items_per_manufacturer_subform.Form.Controls("txtField" &...

I am creating a form to view certain data summaries of my database. I have started out with the form having controls where the user specifies 4 values. These 4 values are then used to create a query when the user presses a button. So far the data is only retrieved from a query called...

Yes, that is the case. I see the pencil on the record selector, which to me makes sense, because I'm adding records with the form. So are you saying there is no way to prevent the calculated field from emptying while allowing undo (ctrl-z)?

Hey AceMan, The locked textbox gets emptied when I press escape while any other control has focus. If you're wondering why I am slow to reply, that's because I don't work every day. So sorry for that :p

I have a datasheet form (viewing only) that has a buttons to edit or add records. When you click the add record button, a new form will open and one of the fields (a field that needs consecutive numbering) is filled in from code using DMax("[field]", "table") + 1 The textbox for this field is...

I got it working on the data entry form. Thnx for your reply MajP.

I'm making an access database to track returned goods, Access 2007. one of the tables is like this (simplified): Item(ItemID, SerialNr, Quantity, Description) All kinds of items are returned, some have serial numbers and some don't (stuff like screws, plastic encasings, etc). When an item has...

I finally got it working as I want it (as far as I can tell now haha). There also was a very sneaky (to me at least) setting that messed up my validation rules...text fields in a table have a property called "allow zero length". This is set to true by default. So on saving, the empty textboxes...

Ah I got it, thanks PWise. The only seems to be one issue left. This query set CaseClosed to true where needed, but it could also happen that it needs to be set to false when one of the item's actionperformed gets unchecked. Is there a way to incorporate that into this query or should I make it...

I still haven't been able to figure this out, can anyone help?

Hi lameid, I have tried setting focus on all the controls on the form in the beforeupdate event, but that doesn't seem to fix the problem. From what I understand, PHV means that I have to check for empty values in the beforeupdate manually. As far as I can imagine, that's probably because using...

I have made a very stupid mistake here. My opening post and thread topic say that validation rules are ignored, but that is not true. The only problem is that required fields are not checked, so when I use my save button I can save the record with a required field empty, which should not happen...

I'm not sure where to use those queries. I have tried it in the query design of the query that is the recordsource of the form I'm displaying the data on. There I tried changing "field" for the CaseClosed checkbox to both: CaseClose: update Receivement left join(Select ReceivementID from item...

Hi lameid, Thanks for replying. As you can see I am a newbie to programming so your tip on simplifying the beforeupdate procedure was very welcome :) The form design shouldn't be saved, that was not intended, thanks for pointing that out. I have tried your suggestion, changed the code to...

Simplified, my tables are: Receivement(ReceivementID(PK, autonr), CaseClosed(checkbox)) Item(ItemID(PK, autonr), ReceivementID(FK,nr), Finished(checkbox)) So each receivement has multiple items. When the "Finished" field is checked for all the items a receivement has, the "CaseClosed" checkbox...

Hi guys, I have a split form that only shows records, no edits, adds, or deletions. On the form I have a button "edit", to edit the selected record. It opens a popup form in dialog mode. The popped up form has a "save" and a "cancel" button. The way I need this to work is that no changes should...

Thanks for the links MajP. I will look into it once I have fixed some other problems with my app.