Search results

This worked like a charm! You are fantastic! thanks a ton! :)

well because when entering the date they are accustomed to dd/mm/yyyy and the form only seems to work with the mm/dd/yyyy format so until they get used to it I suspect they'll be some confusion :)

Bob, You are right, that was it, Thanks alot. although i suspect this will cause some confusion for the users. I'll see what I can do about it. Thanks again.

its dd/mm/yyyy. and I've set the date format for the [Date Of Request] field and the date range text boxes accordingly. would you like to me attach a sample?

Hey Bob, yes indeed Sub_Job is text not numeric, and it is technically working now, expect strangely it is now displaying incorrect results! ie: sometimes it displays results that are out of the date range, sometimes it doesn't display results that are within the date range. What could be the...

Bob, It did not work, after I click on the combo box, it prompts me to enter a value corresponding to the same option I'm selecting from the combo box.

Hi, I am using this code to filter a List Box based on a Date range and a Combo Box selection: Private Sub Combo139_AfterUpdate() Dim StrgSQL As String StrgSQL = "SELECT [User Name], [Date Of Request], [Description of Problem], Status, Sub_Job FROM QRY_SearchAll " & _...

David, Ok here it is basically: This is the cabinet/cabint items form: As you can see, it shows the cabinet and its contents. the user of course an add/modify cabinet names and contents as necessary, I managed to do this using the continuous form. Now, what I want is the procedures form...

David R: Yes correct, the cabinet has only a date field and the technician's name field. and a field for any other remarks.

Edit: I would just like to add that I need the user to add/remove/modify the items in the cabinets and/or cabint information as necessary that is why i needed to user a form/subform. Then i would like to take the existing data and apply the necessary modifications onto a form to add "action...

Ok, I understand what you're saying, and I've read the article you linked, and I understand it. but I don't see how this helps my problem. and I'm not complaining or anything, on the contrary I welcome your help and input very much, I just don't see what I'm missing.

Mihail: Maybe I haven't made myself clear, this is not a matter of database normalization, I don't know how to build the form. I need a form that will read the data from the previous tables, and add them into a new table. without changing the structure or data in the original tables...

Ok I'm not sure how to explain this so i'll try my best to be as specific as possible. I need to build a preventive maintenance form that records actions taken on cabinets for certain dates, each cabinet is maintained weekly and contains multiple items, the actions are records for the items...

Hey guys, I have a form that is filter based on a combo box. I would like to add another filter for date. but the code I'm using for the first combo box doesn't work for date. the code is: ----- Sub SetFilter() Dim LSQL As String LSQL = "select * from Preventive_Q_View" LSQL...

Hey guys, Beginner here.. I have a report that is filtered based on a multiselect listbox on a form. which is working fine. what i want to do is add another multiselect listbox and filter the report based on both listboxes. which i don't really know how to do. Here is the code i'm using...

Hey guys, I have a report that is filtered based on a multiselect listbox on a form. which is working fine. what i want to do is add another multiselect listbox and filter the report based on both listboxes. which i don't really know how to do. Here is the code i'm using: Private Sub...

Hey guys, Beginner here. I have a table called Prod_DB, in this table i have a field called "Country" which stores country names, and then i have many other fields for years, ie: a field called "2009" which stores values (production in Kilograms) relating to the country in field "Country" and...

Yes, it is placed in the details section and is bound to a field. I've attached a copy of the accdb file. you must first select Dept, then SEction in the main form, then in the subform you must select: printer make then printer model then ink model> then enter a value in "Used" after update of...

ok, the subform is a data entry continuous form. you select an item, enered the data, the select another item and enter the data and so on. you know. and the invisible textbox is placed in the subform.

Hi, I have a main form and a subform. The main form is based on an "items" table, and the subform is a continuous form based on a "subitems" table, they are lined via "item_id". in the subform I have the following controls: Item, Used, Available. The user chooses the "item" from a combo...