Search results

How many rows of data can I have in my Access database table before I have to seriously start worrying about awful performance? I know this topic/question has been floating in the Internet for a number of years. But it seems that the answer is always to walk away from Access into SQL and other...

Good afternoon, My dilemma has to do with getting a sort to “stick”. Here’s what I have: A table with 3 columns: ID/PK field – PRINTORDER – PART A form that displays the record for each part A Listbox control in the form with 3 columns (same as first bullet point) the ID field being hidden...

Hi, Ever since I started using Access, I've been told to make use of Tables in order to populate my combo boxes. As such, rather than setting up, say, 4 tables to hold just one column of combo box choices each, I use one table and each column then supplies the combo box choices. This works...

Hello folks, Perhaps I've been starring at this too much. What I am trying to do with the following WHERE condition is replace BETWEEN with >= And < operands for my date range. I've played around with the placement of them to no avail. Any help is appreciated. Thank you much...

Hello AP folks, I hate to resurrect this topic but I am finding myself in a bit of a bind and have been starring at code for days on end now. In the most simplest of ways to explain it, I have the following: A table that houses a picture file name and its corresponding path (just to my...

Hello folks, I got into access about 2 1/2 years ago and I am hooked! Love this program. I have split DBs here at work with ease due to the network infrastructure allowing me to simply place my BE in a windows standard folder and simply link my FE to my BE with a simple DNS address - no...

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

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

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

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

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

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

Hello! Hopefully this will make sense - I'll do my best to explain: I have a form which displays song lyrics in the SongLyrics memo control. Within this form there is a listbox named SelectedSongs. Below the latter listbox, I have a checkbox whereby when I check it, it places the title of the...

Hello - I have a form that allows users to enter a song's: Title lyrics And has a Yes/No field (PrintSong) which selects the song to be printed As the user goes from record to record, they may select this yes/no field to select that specific song to be pulled up in a report in print preview...

Hello! Here's my dilemma and any help would be greatly appreciated: I have a main form that contains vendor names with a subform whereby the end user can enter vehicle data that gets recorded in that vendor's table. So far all is good. The problem: I added a search combo box to the SUB form...

Hello there! I am a beginner with Access 2007/2010 and so far I am enjoying very much what this particular DB program is capable of doing. I've been taught that when I get done developing a DB for someone else, I am to give the other party the DB with the file extension ACCDE. Here's where my...

Hello - Here's my dilemma: I have a table that keeps track of job postings and how many people applied for each posting. So, for instance, I can have 20 people apply for a job posting say....on July 18. On another column I have the shift name for that posting such as DAY Shift. So, I have...

Wanted to drop a line and say thank you for letting me be a part of this MS Access help center. I am relatively new to Access. I have a good working knowledge of VBA and I am starting to really dig Access. I hope one day I can help someone.