Search results

I thank you for your thoughts on this Jack. I have developed several other projects but when pen and paper started on this one, too many unknowns came to mind; thus the respectful post here for guidance... I've studied the sample produced from the wizard but have several questions regarding...

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 Jack, This can serve in an application I have as well; however, I get the following error: Compile Error: User-defined type not defined Access 2K highlights the following after Dim declariation: recClone As DAO.Recordset Any direction... Jim ========================== Disregard! I...

Hello Wayne, The form's "Current" Event did the job! I did have to keep the checkbox's "After_Update" Event with the same code in the event either checkbox needed to be updated... Question though... Since there's redundant code(just a few lines), would it be possible or even worth the effort...

I'll slightly modify the code samples into one snippet and place it into the form's OnCurrent Event and see what the results are... I'll report back with my findings... Thanks again!

Thanks for the reply Wayne! However, since there are subforms involved, it's set to single form view... So, is there a way to control each record's state for the two checkboxes and only change the current record on the form without effecting all the form records...? Thanks again!!!

I thought about an Option Group but the two checkboxes are actually unrelated... chkBox1 is for items "In Service" or Not; while chkBox2 is for items that have been "Terminated". So, items that have been terminated should not have the ability to check the checkbox "In Service" or Not. Perhaps I...

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...

Getting frustrated... Hello again, DAO 3.6 is already checked but I did notice the following check box: Missing: Microsoft VBScript Regular Expressions 1.0 Additionally, I now receive an error(Can't find Project or Library) for the use of "Format" in the following code that highlights the...

Hello Kevin, I'll give that a try when I get back to work... Thanks for your patience!

Hello Kevin, Replaced the module with the one you supplied and received a compile error, Can't find project or library... Access 2K opened the VB window and selected the following text: String$ from this line: strUserName = String$(254, 0) Possibly, I don't have a Library installed...

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 Kevin & Wayne, Attached is the module as a txt file... I didn't see any missing "End Function" statements needed but question the "Private Declare Function..." which seems to be giving me trouble doesn't have a closing statement...? Again, Thanks for you time on this mess! Jim

Hello Kevin, Yes, I compiled the DB and received the same error: Does this have to be in a seperate module all by itself...? As it is now, I have added this code to an existing module and for some reason Access 2K draws a line under the function listed above as if it's part of the function...

Hello Wayne, The function is in a module and I've replaced "Private" w/ "Public" with the same results... I also took Kevin's advice and added an "End Function" at the end of the first declared function in the sample code to no avail... Any other suggestions as to why this code isn't...

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...

Slight similarities... Hello, I don't want to switch this topic but thought I could get some quick help on a related issue pertaining to calculating ages... I've searched and found solutions for calculating ages but wondered why I receive an error (function entered can't be used in...

Thanks for the reply! Hello Wayne, I've posted a link to an image of the relationships for this DB: Relationships.gif My thinking was to generate an SQL string for the filter since there are a few fields that an end user could search by... It was mentioned by another person to create an...

Hello again Wayne, You are correct; the Search Form is unbound. Perhaps, I could just hide the form... I thought utilizing SQL would make the search/filter more flexible and efficient... The Search Form has address related fields that I need my end users to input data to filter/retrieve/view...

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...