Search results

I know this may sound a little strange, but I was wondering if I could query an array or a temporary recordset with a table. Like if my array or recordset contained the following: 9/3/2002 0 9/6/2002 0 9/12/2002 0 9/15/2002 0 and my table contained 9/6/2002 50 9/12/2002 125...

Okay, I know this is an easy one, and I've looked for the answer EVERYWHERE! I want to use a union query as the rowsource for a listbox, so that I can have a row that displays "ALL" before the rest of the queried list. What's my SQL statement look like? It's been a long day and I think I've...

Is anyone familiar with the query options dialog form for MS Word (for MailMerge)? It's a dynamic query builder. I would love to incorporate a form similar to this in one of my databases. I can create it myself, but I thought why re-invent the wheel. I'll start coding it, but hopefully one of...

Okay, I could probably find this if I searched harder, but it's getting really frustrating, and I'm sure one of you can answer the question pretty quickly. What is my object name parameter for refering to a subform in the GoToRecord method of DoCmd? I've tried: docmd.gotorecord, acdataform...

Alright you guys, time to pay the piper! I'm having some SetFocus problems and maybe one of you can help. I have a main form (frmRGAMain) with a command button (cmdProcess) and a tab control with a few pages. On page1 I have a subform (subReturnPartDetail) that is set to continuous forms...

My form is based on a query for a main table with some of the fields being originator, creditBy, and restockby. The query links the employee table to the main table to create a sort of lookup query so that when the employeeID is set as originator on the beforeinsert event of the form, the...

This is a little on the higher end of VBA, but I would appreciate any help or direction you guys can give me. When my user wants to process a form I prompt to preview,print,fax, or email the form. I've coded everything except the fax, because I want it to be more intelligent than I can make...

I'm using the Balloon feature of the Assistant to prompt the user to select how to proceed with a process. The problem is that I want to exit sub if a problem occurs in the callback. I will paste the code below, but essentially here is what going on: The record begins as status=1. The user...

I'm using an unbound control on a report to show address information. I'm running into a problem with my controlsource function. Instead of doing a return, chr(13) is entering a little square character. I remember reading another post about alternatives to using chr(13) (because it's unreliable)...

I need to check some criteria for some textboxes on my form (containing 5 subforms). I have set the tag property to do this and I want to loop through the control collection and verify some things. I know how to achieve this with my main form controls, but how do I include all of the controls on...

I'm tossing this around in my head, but I thought I might make use of your input. We one of our VB applications uses an Access backend (I KNOW). I need a way to modify the table design in the customers database without losing any of their data. All we need to do is add two fields. My thought...

I need to code a procedure to run when the user presses F1 while in a particular field. What is the corresponding value for F1? Is this as easy as it seems? OnKeyPress If (this is the part I'm not sure about) then MyProcedure End If

You know that cool dialog box that windows help uses for the find tab? The one where you begin typing the word to look for and the list box displays only corresponding words. I definitely need this kind of form in one of my databases. I know how to create one, but I figured if one of you guys...

I have a large project coming up, and I want to get a handle on some ideas before I begin implementation. This will be an ongoing project, so any and all suggestion are welcome anytime. (In other words, this thread is never dead) The skinny: My company creates Owner/Operator Manuals for the...

Here's my setup. Table on the network. Forms on the hard drive. Keep getting a message when scrolling one record to the next. "Microsoft Jet database engine stopped the process because you and another user are trying to change the same data at the same time." So I look to see who else is...

I have a program that consistently gets this error when trying to modify a field value. If the user back out and reopens, everything is fine, then it happens again a few minutes later. Does anyone think that this is caused by the form being based on a lookup query with Dynaset...

Ok. I know the long way to do it. For each varposition in listbox.itemsselected docmd.openreport "rptname" where blah blah next varposition Is there a way to add all listbox selections to a recordset and print only or preview only those records? The method I know would open a separate report...

I am using a list box to select records to copy. I have this part working great. Now my box of rocks user (sorry he is!) say "Well what if I accidently copy the wrong ones?" So he needs a delete button. My question is, how can I code the button to delete the record from the recordset. What does...

I've been tossing this around in my head,and I thought I would ask for an opinion from other experienced programmers. If I have a form that multiple users access, and I set the recordsource for the form based on user input, and another user accesses the form with different input, what effect...

I know what I would like do, I just hope I can explain it right. I have a Client/server database application that is on our network. I plan to split the database, but have the front end forms on the network, and the backend tables on the client hard drives (it absolutely must be this way). Most...