Search results for query: *

Has anyone ever printed a large relationships diagram that's too large to print from the relationships window? Did you use a third party software? Any suggestions? Thank you Directorz

Hello experts, I'm incorporating inventory into a db using the NorthWind inventory as a model and my db tracks equipment maintenance. When any maintenance is performed, a work order is always completed, thus I have a work orders table which needs to be tied to the inventory model. The work...

Could someone assist with SQL in creating a calculated field. I need to show a meter total and I have 2 tables as follows: Tbl1 MeterID – pk InitialMeterRead Tbl2 MeterReadID – pk Ref_MeterID – fk to Tbl1.MeterID MeterRead Tbl1.InitialMeterRead is the start reading of a meter. Subsequent...

Good morning experts, I’m attempting to track various meter readings in a vehicle maintenance db. I currently have 5 tables laid out as follows: TblVehicles VehID – PK TblMeter MeterID – PK Ref_VehID – FK to TblVehicles.VehID Ref_MeterType – FK to TblMeterType.MeterType TblMeterRead ID – PK...

Using 800 x 600 resolution, what is the typical size of a form. I read 7-1/2 x 5-1/4, then 6-1/4 x 3-3/4 but am confused. Thank you Directorz

Is there a way to get font sizes <8 in labels and textboxes...I can't seem to find it. Thank you Directorz

I'm having a tough time with what seems to be rather simple, I just can't see it and need a second set of eyes. I have the following arrangement in a vehicle maintenance db: TblVehicles ID - pk VehID TblServiceInfo WorkOrderNo - pk ID - fk to TblVehicles/ID DateofService Odometer...

I've got a mainform with a pop up subform. While the focus of the mainform is on a record and I bring up the subform, I need to have the subform show the current record that the mainform is focused on. If I change the focus to a different record on the mainform, I need the subform to change as...

The solution escapes me...Is there a way to lookup the value (contents) of a memo field in one table, and store it in another field of a different table, (similar to using the combo box wizard). Thank you Directorz

Hello experts, I’m stumbling with a treeview. I’ve created my first one and have it populated. I have difficulty in understanding how to associate the value that a node represents to a record…let me elaborate. The db I’m working on focuses on periodic maintenance of cars. Maintenance schedules...

Good morning, I am having a problem at the point where I close a form. I receive an error #2169 with no explanation or option other than 'OK'. What language do I need in the code to display what this means in order to clarify it and give a user other options. Currently, this is the coding I...

Hello experts, I'm running XP Home and, as an administrator, am attempting to set up a user. The user name apparently was deleted or disabled as it does not show up in the user window. However, when I enter the user name, I get 'username already exists'. I know this can be corrected in XP Pro...

I have a combo box on a form used to look up a record based on a value selected by it and it functions correctly. However, when I want to add a new record, the form is cleared with the exception of the combo box, which still show the previously selected value. How can I get the combo box to...

Hello experts, Is there a way to limit a form to show only 1 record by disabling the scroll feature of a mouse wheel while in the form Thank you Directorz

I've got a form based on a 3 field table: ID - pk Description - pk Serial number The ID field of the table is linked to vehicles to which serial numbers belong and displays the vehicle number. The form was created as a continuous form and is used as a subform on a multi-tab main form. The...

I am exploring the use and setup of a treeview in my db. using a recursive procedure, I see there is a strpointer field, strID field and a strText field. My problem is that I have 2 tables. Table 1 has parents and children in a field. Table 2 has grandkids, so to speak. Is it possible to...