Search results

If these are values already in a field then why are they not displayed already? I don't understand.....

I agree, keep a history in a different table. 2.) Include the "unique" key in the dropdown box and just hide it in the Column Widths column by making it's length 0". Use the unique key column value as a parameter in an update query to change the field value. strSQl = "UPDATE...

I don't think you can change the mdb icon without changing them all for Access. If I remember correctly, it is possible through the developers package using distribution. It might be for mde extensions only though. You'd have to do more research on the topic.

Icon in startup I normally make a folder on the root of c and place the icon and database front in it. If you click on Tools, Startup there is a place to browse for the icon for the application.

Good work! Yep, looks like it would work! Never thought about doing it that way. I always use vbNewLine instead of vbCrlf. I read somewhere that it was faster. I don't know how true that is but "there ya go" LOL Good work KenHigg

Hmmmm At first I thought IIF statements would be the sure but with 9 text boxes maybe not. Maybe use sub reports for the address line and switch between the sub reports using a condition during report open. My only other thought was to use a LBound/UBound array and use concatenate based on the...

At first I thought IIF would work but since there are 9 text boxes I don't think it's feasible. You might be able to create a sub report for each condition and choose which to insert using the condition. My only other thought was to use an LBound/UBound array.....ugh!

Nz("") Use NZ and dlookup prior to adding the record. Example: Dim intRec as Integer intRec = nz(dlookup("FieldName","tblName","[RMA_ID]=12345"),0) If intRec > 0 then 'There is a record else 'Code to add the record end if I use this trick all the time. Hopefully you'll understand.

Re: Dk Why not use the InputBoxDK module? Option Compare Database Option Explicit '//////////////////////////////////////////////////////////////////// 'Password masked inputbox 'Allows you to hide characters entered in a VBA Inputbox. ' 'Code written by Daniel Klann 'March 2003...

Sorry! (inputboxDK) For some reason, I didn't see the same thing posted above when I was reading this forum. Looks like the same guy wrote it, altered code, modified a month later...LOL

Masked inputbox I added this to my Disable-Shift routine to enter. It's been working for 3 years now. Make a new module and paste this code into it. Option Compare Database Option Explicit '//////////////////////////////////////////////////////////////////// 'Password masked inputbox 'Allows...

I forgot to mention, I made a module called modMaskedInputBox and call the function when I need an inputbox with a masked input line.

Masked Input Box (DKInputBox) I ran across this piece of code a few years ago which I have used to make Administrative Passwords to access, unlock, etc., databases. It saves me a lot of time on creating forms just to enter a password. Option Compare Database Option Explicit...

I ran across this piece of code a few years ago which I have used to make Administrative Passwords to access, unlock, etc., databases. It saves me a lot of time on creating forms just to enter a password. Option Compare Database Option Explicit...