Help

Set parameters for nested query
Well, I've been searching around the groups for an answer to this one, and none of the suggestions seems to be working for me. I'm almost positive that this is a simple fix, but for the life of me I can't figure out what I'm doing wrong. I have a form that uses a query as its recordsource; I'll call the query qr... 21 Jul 2008 01:47

Sync the Rankings
In WinXP w/ AXP. I run a weekly query which produces a report in which there are 3 relevant fields and data types: [Ranking]-text, [Team]-text & [AggScore]-number. Each week, the aggregate score is tallied and entered into the db via form. The highest (largest) score will dictate the highest ranked team. To pro... 19 Jul 2008 17:04

Numeric Data values messed up with linking excel files
Hi, I have a perfect file called "Products.xls" that I link to my MS Access 2003 database and everytthing looks good in that file. When I view the same file after linking in my database the data values of records in "tblProducts" are incorrect. For example the tblProducts has a field called "PackageSize" as li... 18 Jul 2008 21:39

Couldn't use <name>; file already in use. (Error 3045)
The specified file is currently being used by another user or session. Wait for the other user or session to finish working with the file, and then try the operation again. So, I've got db1.mdb open, yeah. I select a report in database window, yeah, press ctrl-C, then change to another application window on same... 18 Jul 2008 12:21

Actualizing the table
How can i actualize the table 'Products' where i have for example field 'Stock level' from the Form 'Orders'? When order incomes to warehouse the amount filled in form should be added to total Stock level of ordered product in mentioned table. ... 18 Jul 2008 10:17

Another OT question
Hi Everyone, I am trying to figure out how I can 'receive' audio from a microphone into an application. The audio needs to be 'streamed' and not actually recorded. The idea is to perform a type of analysis on the audio stream, and then record the results of the analysis. Does anyone know a way that I can achie... 28 Jul 2008 04:52

Expend by typing in a combobox
Dear reader, One of the properties of a field is "Auto expand". Is this the property to able and unable the expend by typing. My experience with "Expend by typing" in a combobox is not so good. Sometimes it works and sometimes not and I can't find way. Is there some setting what I overlooked? ... 18 Jul 2008 19:36

#Name? error in Access 2003
I'm designing a report and cannot pull data from a query. The control gives me a #Name? error when I do a print preview. I never had this problem with Access 2000. Any ideas? ... 19 Jul 2008 23:13

Long strings get truncated in Access
I have an access database that has a field (type memo) that keeps very long strings. When the value of this field is very long, my Visual Basic 6.0 code does not return the whole value and truncates it. I just read it using standard code like this: storeId = rstMsg!storeId where is defined as: Dim stMsg As AD... 18 Jul 2008 01:04

Transparent TabControl in A2K7 and Windows XP
Ran into an inconvenience with TabControls yesterday. I found a partial explanation from Allen Browne on the MS message boards explaining when it happens, but not why. I thought Stephen Lebans (who's done a little work with this for his multi-colored listbox class), or someone else might've figured this out. Her... 28 Jul 2008 09:59