Search results

Hi theDBguy. Thanks for reply. I attached Access file where in the fDeviceType I would like to check duplicate by two values BrandID and DeviceType.

Hi All. I have an input form that asks for a Brand name and Device type (PC, Printer, Monitor, and ets) . What I would like to happen is when a user selected brand name from combo box cboBrand and then enters Device type in txtDeviceType text box that already exists in the tblDeviceType table...

Pat, just tell me about the structure and design of tables and queries that I used to populate combo boxes. Do I fixed in correct or they still have problems? And if they have problems. What need to fix? Thanks.

Hi Pat. Thank you for continue help. I'm new in Access. I will try briefly describe what I would like to create. I'm trying to create inventory database. The f_Device - Device form will give user ability to add a new device to DB. I would like when user will open form the all combo boxes display...

Thanks that continue to help. Your version of the form is ran without error message. But the cboModel and cboHardware not populated. Thanks.

Hi Pat. Thanks for replay. I redesign tables by this way: 1. Brand table keep same 2. DeviceType table modified to: DeviceTypeID, BrandID, DeviceType 3. Model table modified to: ModelID, DeviceTypeID, BrandID, Model 4. Hardware table modified to: HardwareD, DeviceTypeID, BrandID, Hardware Also...

Now the form ran without error message. But still I have 2 problems: 1. In cboHardware I cannot select value. 2. The cboModel not populated when values in cboBrand and cboDeviceType selected. How fix those problems? Thanks.

Hi All, I create form with four cascade comboboxes. The cboBrand and cboDeviceType comboboxes are working good. But cboModel didn't display list when values in cboBrand and cboDeviceType are selected. But when I ran query by itself that populates cboModel combobox it works OK. The fourth...

Insert like you suggested line in Form_Load event: Me.cboType = 0 and when ran form got error message:

Hi arnelgp. Thanks for reply. Do you have idea how to display default value for cascade comboboxes (in my case 4 comboboxes) when form is ran? Thanks

I don't have problem to display the default value for first combobox in cascade set. I cannot get result to display default value for 2nd, 3rd, and 4th cascade combobox. I tried to use Form_Load and Form_Current event. In both got error message: In line Me.cboType.Value = Me.cboType.ItemData(0)...

In Form_Load event I insert that line: Me.cboDeviceType.Value = Me.cboDeviceType.ItemData(0) But it didn't help. Thanks.

Hi All. Creates query with default value to populate the ComboBox: SELECT DISTINCT DeviceType.DeviceTypeID, DeviceType.DeviceType,1 AS SortRow FROM (Device LEFT JOIN DeviceType ON Device.DeviceTypeID = DeviceType.DeviceTypeID) LEFT JOIN Brand ON Device.BrandID = Brand.BrandID WHERE...

Hi All. I have form with some ComboBoxes. To display default text in load form event I add code: Private Sub Form_Load() Me.cboBrand = "Select Brand" Me.cboBrand.ForeColor = 11250603 Me.cboDeviceType = "Select Device Type" Me.cboDeviceType.ForeColor = 11250603 Me.cboModel =...

Hi All. I have problem with Access 2016. It is working not properly. For instance, when I modified form, save and try to open in form mode it stack MS Access. After that I cannot do nothing and must to use Task Manager to close Access and then reopen it back. When I selected any Access object...

Hi All. Now when I open one form in view mode I cannot open another form in any modes. Is it possible to open some forms simultaneously? If yes. How it to do? Thanks

Thanks. I figure out how it to do.

Hi All. How to make opened table, query, form movable. Drag their to another monitor or resize as need it. Is it possible? Thanks

Hi All. I created form from a table. But all fields are block together. Around all fields I see dotted line. How to unblock/ungroup the fields? Thanks

Hi All. I try to create form to add new equipment. In the form I created cascade comboboxes: Brand, DeviceType, Model or Device. How it works. When user open form to add new equipment, first of all, user must to select brand (Dell, HP, ets or blank.). The cboBrand is filtering cboDeviceType list...