Search results for query: *

Have a simple query that works on Access XP and 2000 but does not on 2003. Any known issues?

I am attempting to move a value in one list box to another. The problem is is that the value contains a comma in it. It's a chemical database so removing the comma is out of the question. Any suggestions?

How is this done?

I am building a reports form that needs to move data from one list box to another for reporting. The problem is is that it is a chemical database and some of the compounds have commas in there names. For example, 1,3 diaminopropane. When I try to move the data, the comma separates the name into...

Is this possible? The data is fairly simple, A(compound) and B(compound) equal X(Value). I would like to have a query/report that would have all the A's on the X axis and the B's on the Y's axis ALONG with sum, avg, and stdev. Example: | A | B |...

Why does this not work? I have a form the has two option/radio buttons, one Yes(optYes) and one No(optNo), in the same frame (fraDate). If No is selected I would like all values returned. If Yes is selected I would like to use the Between statement to input parameters. Here is what I have...

Why doesn't this work; IIf([Forms]![frmAdvQry]![fraDate]='2',[tblNotebook_Sub]![Date],[Forms]![frmAdvQry]![fraDate]='1' Between [Start Date] And [End Date]) I setup a form with a frame (fraDate) and two option buttons inside it (optYes and optNo). I would like for the end user to be able to...

I would like to add Radio buttons to a form that give the option to search by date. I would like the radio buttons to be Yes/No and if Yes, then the message window will appear and ask for your parameters. If No, then ignore parameters to search by date. I just don't know the...

I need to setup a query that has multiple statements but that ignore a statement if no value is entered. For example; I want to query all my store for people with the last name JOHNSON and who are in STOCKING and who work in LOS ANGELES. I know how to set that up, but what happens if one day...

For example, when you log on to your network your password looks like asteriks. Is there any way to setup a textbox so when you type in it its encrypted/astericks?

Could anyone tell me how to setup passwords for individual databases located on a network? I have several (4) databases on my network and each one needs its own users. I don't want to have to go to each employees desktop and configure there MSDE.

With AutoNumber set to Random is there any way to limit the range of numbers Access pulls from and also can you add prefixes? Example: Currently -2031668925 Ideally - R123654