Search results

Hello everyone - Can anyone tell me why I can't set focus on a text box after I update a combo box? I have a form (frmLeanAssignment) with a combo box (AssignedTo). This combo box is set up so the user can select mulitple names from a list in the drop down box by checking a box next to the...

Cool! I didn't know about that little trick. I tried it myself and it worked perfectly. Thank you Bob for the quick response.

Hello everyone - I have a form (frmReceiptEntry) which contains a subform (sfrmReceiptDetails). The form/subform design works fine as it is. I was approached by a user to see if I could stop an error message she receives when she accidently starts to enter a line she doesn't need. The...

Oh, of course. :o You're wonderful! I don't know what I would do at times without this forum! Thanks again!!

Oops I may have spoken too quick. I added another lean idea number so there are now two (#1 and #2). When I run the query now, it concatenates the emaill addresses for all the records whether they were assigned to that specific lean idea or not. For example, #1 was assigned to John Doe and...

Ah ha!! That was it! If I take out the parameter "forms!frmLeanAssignment!LeanIdeaNumber" from the qryLeanAssignmentEmail the concatenate query works just like I wanted it to. Oh what a beautiful sight! :) Thank you for walking through this with me. Another lesson learned in the...

Sorry. I just viewed my post and noticed the spaces between the "ma" and the "il" in the query name "qryLeanAssignmentEmail". That was a mistake in the post. In the actual query there are no spaces.

Here are all the variations I have tried: SELECT tblAssignedTo.LeanIdeaNumber, ConcatRelated("EmailAddress","qryLeanAssignmentEmail") AS AssignedToEmailAddress FROM tblAssignedTo; SELECT qryLeanAssignmentEmail.LeanIdeaNumber, ConcatRelated("EmailAddress","qryLeanAssignmentEmail") AS...

WOW! Thank you both for the lightning fast responses. :) These are examples that I saw and tried to adapt myself several different ways but I always get the following error: Error 3061: Too few parameters. Expected 1. What does this mean?

Hi everyone - I have been trying to figure out this concatenate thing on my own for two days now and I cannot get it right so I am asking for assistance. I have found several examples of code to combine one field's contents from two different records but have not been able to get any of...

Hi everyone - I have an idea in my head but, unfortunately, no ideas on how to make it a reality or even where to start. I have a query created right now that "shuffles" a group of selected order selectors using Randomize/Rnd(). This works perfect and shuffles them every time the query is...

I tried searching for a similar thread before posting and didn't find anything. Of course, almost immediately after posting, I found one. I used the Replace function to remove the quotation marks and it works perfect! I apologize for the extra post.

Hello everyone - I am trying to import a .csv file into an Access 2007 database. The problem I am encountering is that when the information is imported to the table in the database, the data in the fields is all enclosed in quotation marks. Is there a way to eliminate the quotes on...

Thank you to all who replied. With your great suggestions, I have come up with two different ways of presenting the data. Both of which look very professional. Thank you all for your assistance and patience! :)

I didn't receive any notices that anyone replied to my last post so I didn't know those other replies were out there. Now that I went back and looked there were quite a few more. I didn't think that the String() was going to work because I need to show even a 1% increase but then I figured...

Thank you, Linq. Sounds like that is my problem. I have to have the form set to continuous so that each batch shows on the screen at the same time (it will be projected for the order selectors to see so they are aware of the workload and progress of the batch throughout the day). Would you...

Hi and thank you for the very quick response. I have tried it under every event that I thought would work and none of them made the field width different for each record. Currently I have the following in the OnCurrent event: Private Sub Form_Current() Me.PercentageBar.Width =...

Hello everyone - Is it possible to vary the width of a field between records? I have a form with fields "Batch", "TotalUnits", "Units Done", "UnitsRemaining" and "PercentageDone". I would like to somehow create a sixth field "PercentageBar" whose width is based on the data in the...

Hi Rich - Thanks for the sample of the progress bar. Now that I see it in action, I'm afraid that isn't what I had in mind. I did find something that worked though. I put the following code in the OnCurrent event of the form: Me.boxInside.Width = ([Percentage Done] / 100) * (1440 *...

Thank you r.harrison and vbaInet for you suggestions. Since I was not familiar with creating progress bars, I have been looking at numerous posts and see that it involves a lot of code which I am a beginner at to say the least. Would you be able to help me with that? I am not sure the pipe...