Search results

Hello, Looking for some input from the experts... I'll try to be brief... I'm taking on the project of creating an Inventory System for my Fire Dept which will strictly track medical supplies. I've looked at the one created within Access from the wizard but feel I'll need to create something...

Hello, Couldn't seem to find similarly related topics so I'm seeking help from the gurus... What is the best way to enable/disable 2 checkboxes I have on a form. Enabling them will be based on which one is selected or updated...? If chkBox1 is checked, I would like chkBox2 to be disabled...

Hello, I'm starting a new project for my department that basically needs the following features: Track current inventory for department uniforms(pants, dress shirts, t-shirts, etc) Track current inventory for personal protective gear(ppg) (helmets, pants, coats, gloves, etc.) Track inventory &...

Hello, Having a little difficulty on sample code I'm attempting to implement after searching the archives... I'm utilizing the following code: ------------------------------- Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As...

Hello, I'm attempting to Filter a main form with a tab control that has several tabs, one of which is Address. On this tab, is a SubForm with basic address information such as street number, street name, direction, type etc... On the main form, I have a cmd button Search that will open a...

Hello, I have a small project that I want to create but felt like running it by everyone for some input... Basically, the docs will all be the same format such as an interoffice memo. I'm not sure the best route to take but the following are a few elements I would like to include in a DB that...

Hello, How can a reference the value of a ComboBox that user hasn't selected a text value? The ComboBox is based on a value list. I have a checkbox on the form that if unchecked by the user or left unchecked will need the user to select a value in the ComboBox. My thoughts were to evaluate if...

How can I stop a form from creating a new record when tabbing through the controls on the form...? My end users are continuously creating a new record on tables that have one to one relationships. I want to stop them from doing this... Any direction appreciated!

Hello, For some time now I've been creating small DB solutions to accomplish various tasks such as Scheduling, Track Training, Overtime tracking, Vacation Tracking etc, etc... All of these work fine and some have been implemented for a couple of years now. All of the various DBs have been...

Hello, How can I add a new record in a Subform that is generated from a button on the Parent form...? Then set textboxes on the Subform to values from code...? Previously, I was able to accomplish this when all the textboxes where on the same form based on the same table; however, I have...

Hello, I'm moving a field in a Table A w/ data to another Table B and would like to know if a Update Query can accomplish this...? The field in question is not a primary or foreign key but I don't want loose the data currently stored in table A I have copy/pasted the field into Table B; now I...

I've attempted several different concepts to no avail... I would like to filter MainForm by address fields criteria available on a subform located within a 'Tab' container. I was invisioning a "Search Button" on the Main Form that opens a SearchForm based on the address fields: StreetNumber...