Search results

Thank you John for your input. I still get the same error message. I'm using Access 2010. Does this error have to do with Reference or something? I'm totally clueless what all those References mean. When I go to Tools, References, I see the following checked and in that priority order. *...

This seems simple, but I'm getting error message. See attached. I'm trying to assign a variable to the value based on a selected item in a list box. I believe this is called unbounded list because I listed in the row source as "1,2,3,4...". What I have is below... Private Sub...

I'm trying to build a restaurant POS system. In a form, the waiter can select the physical table when creating an order. Typical physical tables (with chairs) may be denoted as A1, A2,...B1, B2, B3.... It's easy to customize a list box or buttons to fit any given restaurant, but let's say I...

jdraw, That would actually be ideal if I can build a form to self "autopopulate" the buttons with captions as you described. Do you happen to know how?

Hi Sean, I was able to create text is two lines by pressing Shift + Enter.

I am able to set a variable to equal to the caption of a command button. However, if I want to include a foreign translation of the caption on the second line, how do I assign the variable just to the first line only of the command button and ignore the second line?

OrderID is number...integer

This seems easy enough, but I'm not sure why when I test it in the Immediate window, I get value of 0, when I know it should return something like 386. Basically, I want to set A public variable to reflect the highest ID (OrderID is the field name) in TABLE, tblOrderID. My code is below...

Hi, I have a combo/list box that is populating a list of telephone numbers. Because most of these numbers contain two different area codes. I would like to create a button that would automatically fill the first three digits with either XXX or YYY before they type and set the focus right...

As it turned out, there's no wizard for toggling button, unless you choose the Option Group. Within that wizard, it does give you an option to choose toggle button.

Doesn't the toggle button have a wizard feature too? Yes, I already have the magic wand selected. When create a generic button, option group, combo box...etc, the wizard comes up, but when I select the toggle button, nothing. Has anyone experience this before?

I'm surprised not to find in my search in this forum, but I'd imagine this is feasible, but perhaps it's not as easy as I thought. Is there a way to obtain telephone number and name from a call that would automatically be filled to a couple of fields in a form? The purpose for this is to...

That worked beautifully. Thanks.

Hi, This seems trivial for you as a code writer, but not so much for me :( I have this form where I am building that allows the users to update information. I want to, when the user, click inside of a value, it automatically highlights and copies that value, so that the user can paste it in...

Hi, I currently connect to many MySql databases stored in a hosting server. I remotely access them via ODBC connections. The question I have is that is it safe? Can the information going through the internet be intercepted? If so, how can I make it more secure?

Hi, How would I go about grouping a set of data by a defined period? Let's say I have data from year 2010 - 2012, and I want to pull data that is grouped by every 15 days, 5 weeks, 6 months, whatever time period?

After further research, below code worked for me. I have Windows 7 MS Access 2010. The code came from http://allenbrowne.com/func-04.html =PlaySound("C:\WINDOWS\MEDIA\CHIMES.WAV") ' Code Starts Declare Function apisndPlaySound Lib "winmm" Alias "sndPlaySoundA" _ (ByVal filename As...

I have followed the article but keep receiving error message of "File not found: mmsystem". The debugger highlights this line in VBA, XX% = sndplaysound(msound, 1)' play mmwave sound.

Hi, I would like to build a form that has a timer to pull a set of data from a query/table. If there's a "New" status in a record, then I would like the form to play a wav file from a location in my hard drive. Can someone help with the code to pull this wav file?

Can MS Access create QR codes, you know, those square bar code looking images?