Search results

DOH! Forgot that part. Thanks dcx. Your idea sounds good, especially if you have a large customer base. I use mine with unique records and my user has a reference sheet.

What about using this in the AfterUpdate property of your Customer Name field: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[CustName] = " & Str(Me![cboCustName]) Me.Bookmark = rs.Bookmark You have a combo box to either drop down or type in the name and the...

I've done something like this on a form used to accept a resolution by a user. I have a Yes/No option group that when yes is selected, the current date is filled into another field. In the AfterUpdate event of my option group: If OptionGroup = 1 Then Me.ResCompleteDate = Date...

Somebody correct me if need be here. You don't need your table to show apples. Tables hold the values to show on your forms and reports. If you want the selection to be restricted to only one choice, try an option group instead of checkboxes.

I have been in the habit of using lookup fields liberally, but have noticed the you more advanced folks don't. I was just reading on another site about the 'evils' of lookup fields. Why is it better to enter these as a value list from your main table? Say is I start with a list of 5 topics...

I have a similar task, I think. I was just asked to start an action item registry. The ordinary task assignment isn't the problem. We have a couple items that come up every 6 months. We don't want to go in and enter this each time, but have it show up on the action item list 60 days prior to...

Pat, I have done some searching and made some changes which started something else. I appreciate your help as usual. If you want the follow up: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52734

Fiz, this took a bit. Sorry. That hint was all I needed. I got tied up on something else, finally did the search and there they were. Just wanted to thank you for the search hint. Sometimes thats all it takes.

Hayley, I downloaded your sample and it works great. I was wondering though if I am disabling a database on a server and some one else gets your sample also, could they enable it? Would the code ghudson shows avoid that problem?

Auto, I would have gone in design view of the form and put a parameter in that way. But it sounds like the pop up form would allow you to give more information concerning the parameter. Is this why the pop up?

I am in the middle of the same problem myself. My form uses a union query to get its data. I had a problem with one user's machine that couldn't run the UNION SELECT query. I changed it to a UNION ALL SELECT and the query will run if I just look at it, but my form now does exactly what you...

I have a form that pulls data from a union query. It also gets data from a few more queries, all with different criteria. Initially, i made the union query with the statement 'UNION SELECT', but one machine in our group kept getting the error message 'can't use a memo field with the SELECT...

Is there a way to block users from entering a database by holding down the shift key and getting to structure stuff?

I'm trying to open a file. I have a databasse in one folder that tracks measures in databases in other folders. So if I see something I need to take care of, I can open that database with my link. This works, but it pops up the File Download window. I click the 'Open from current location'...

This worked fine. It acts like its downloading a file and runs a bit slow. Is that just the way it is? Thanks, Ethan.

I have a table with some contact information. One piece of info is a file location. As part of my process, I generate a note with this file location in it. I set the field up as a text field because in the note it becomes an active link. For example, I have a database in...

I checked the references on my machine and the other machine and they both have the same thing installed.

I have a database that links to tables in other databases. I then pull that data together with a union query. This all works fine on my machine and on another machine in our group, but on the machine it really needs to run from, I get the following error message: Cannot use Memo, OLE, or...

You're talking about making a recordset and loop through each of my linked tables to append to the main table? I've been kicking around VBA a little - enough to know I could get into trouble real quick. I'll dig around and see what I can shake up. Thanks.

OK either our system is coming apart at the seams or this union query is already slowing me down. And I'm only testing with 2 tables. Is there another way to bring the data from these tables together or are you suggesting I use the union query for that and and then base a make table query on...