Search results

You guys are awesome! Thank you so much Mark, ridders and Doc Man.

Thank you Mark. I completely agree with your assessment. It does make sorting much easier. The only annoying thing is running reports when the fields are separated. For instance, if I concatenate my FN and LN to create a "FullName" field, I can't use this field to pull up reports by a person's...

Hi - I know I can develop my db anyway I want but wanted to get some opinions. Quick question: Is it best to normalize first and last names? If I have two Joe Smiths, what does it matter if I have a field for the first name and the other for the last name? After all, the autonumber is what's...

I apologize for the delay in replying Pat. Thank you so much for sharing this! I really, really, appreciate it!

I appreciate the guidance as well Gasman - thank you.

Thank you for the fast response Jack. I appreciate it. I'll certainly do as you have recommended.

Hello - I thought I would make a simple form to keep track of participants attending weekly meetings. I've run into a bit of dilemma: In my "Meeting form" I need to be able to add the names of all the people who are attending the meeting but I quickly realized that in the "Meeting table" I...

JHB & MarkK, Thank you so much for your feedback. I had already tried putting the code in the Form_Current event BUT after doing one more check on it, I realized that I failed to remove the ".text" portion in the event. I simply copy and pasted from the Textbox1_Change to the Form_Current and...

Hello - May be I have been staring at code a bit too long. I have a two textboxes. In one, the user may enter up to 189 characters. The second textbox acts as a "character reader." As the user types in textbox1, textbox2 subtracts the characters remaining and provides the user "on the fly"...

Once again arnelgp and Dave, THANK YOU! I am happy to report that your suggestions worked beautifully. A bit of tweaking here and there on my part but I definitively could not have done it with the solid foundation you both provided. Really appreciate it fellows!

Thank you arnelgp and Dave!! I will thoroughly test the attached. By the time I get home it'll pretty late for you Dave :) I'm not sure where "somewhere out" is for arnelgp so it may be the same for him :) I honestly cannot thank you both enough! So very thankful for forums like...

Thank you for all the replies! :) arnelgp, your suggestion threw an error. I attempted to correct it but no go. Ridders and Orthodox Dave, I had come across Allen Browne's website, in fact the link that you provided. A couple of things where the DLOOKUP function is a bit cumbersome for how I...

Hello - I am using Access 2010. I have a form in which I am using a textbox (SearchTbx) as a search textbox to search through my song records. I have seen posts where single apostrophes are dealt with in the DCount function but I am using an SQL statement. I am not super new at Access VBA but...

**YOU ARE AWESOME PBALDY!!** Worked like a charm - bookmarked your website! Thank you! Thank you!

Thank you for the fast reply pbaldy! I appreciate it. :) Actually, I am using a SQL statement. Which is interesting because, when I don't get any hits, the "Detail" section of my form goes completely blank. It's a music db so when I want to pull a song, the comboboxes list the artist name...

Hi there - This is probably a pretty silly question but is there a way to reload a form and have it show all records? Sort of like when you first open the form? Requery and Refresh do not work and outside of using the DoCmd.Close, "FormName" first and then DoCmd.OpenForm "FormName" I have not...

CJ_London, SPOT ON!! The rowsource was the culprit. Shame on me for not opening the zoom box and checking things out there. Your prescription did the trick! Frothingslosh, I had the field as a number. Thanks again to: missinglinq Frothingslosh CJ_London I appreciate you guys and this...

Thank you Frothingslosh. I apologize. I got so focused on the code that I missed what missinglinq's instruction was. The bound column was already set to 1- still got the same error; no go.

Thank you missinglinq for the quick reply - much appreciated. I already tried pointing the code to column 1 but it returns an error: 3077 However, if I enter a zero then it returns the number of the song within the listbox (the PrintOrderID) and does not assume the "True" SongID per my...

Hi there! I've got a listbox (SelectedSongs) which lists selected songs that is fed by a table containing: My primary key (SongID) then a PrintOrder number and finally the title of the song in the third column. Here's the code I have in the double click event: Me.Recordset.FindFirst "SongID="...