Search results

Let me get you started, but I want to encourage you to get a book on Access, read through the help files (which I think are excellent) and look over some tutorial websites to learn the basics. Forums such as these are really made for specific troubleshooting and not neccessarily for teaching...

I had developed an entire treeview control on a form in my database. It no longer works because the reference is no longer available in VBA. The file still exists in my system folder, but when I try to add it to the references dialog, it tells me that it can't link to that file. Anyone know...

You would use: DoCmd.SendObject to send an e-mail. Use VBA (perhaps when the database is exited?) to test for the certain event and send the e-mail if it has not occurred. HTH

Assuming you're familiar with VBA, I actually don't think that what you need to do is complex as much as it is time consuming. Items 1 and 2 can be accomplished through Access' user-level security. Item 3 can be accomplished when the user logs in through Autoexec. Have a vba function that...

Put a text box (not a label) on the form and place the reference: =[Forms]![Facility Selection For open Quote]![Combo9] in the text box. (As an aside, naming conventions are there to help you in the long run! With a form name that has spaces and a combo that is not named but left with the...

Your SQL would look something like this: SELECT Left([CUSNAM],5) AS Part FROM CCDT ORDER BY Left([CUSNAM],5);

Sure. On the onClick for the button to open the report, put the following in vbCode: DoCmd.OpenReport "YourReportName",acPreview,,"[Date] Between #" & [Forms]![YourFormName]![BeginDate] & "# And # " & [Forms]![YourFormName]![EndDate] & "#" You should also be able to put this data in the Filter...

You can use the Left argument to get the left-most number of letters. To get the first five letters of the customer name, you would type: CustomerNamePart: Left([CustomerName],5) I can't help but think that you need a Primary Key to identify each customer, instead of Customer Name, or part...

I solved it with DCount. The query takes each Sunday from tblSundays and then has this field: NumOfDays: DCount("*", "tblDates", "[Date] Between #" & [tblSundays].[Date] & "# And #" & ([tblSundays].[Date] + 6) & "#")

That's backwards from what I need. That SQL would count all of the dates from tblDates that also exist in tblSundays. Another way to say what I need is to count how many dates occur in tblDates each week (Sun-Sat), linked up to tblSundays (indicating which week it is).

tblSundays - dates that are all Sundays tblDates - dates that occur any day of the week I want to count the total number of dates in tblDates that occur any time during the week (Sun-Sat) of each Sunday in tblSundays. Any ideas?

What I have done similarly is put a label just below the listbox titled "Requery" or the like. I often make it dark gray or something that doesn't stand out. For the onClick event, I reestablish (or requery) the list box. HTH

I rather like not having to declare variables before assigning values. Other programming languages (i.e. Javascript) don't require the declaration. Is there any other reason other than a typo that you would want to force yourself to add a line of code (i.e. a "dim" statement) for every variable...

Another way to do it is with an autoexec macro. Simply create a macro (that can do any of 1000 things, such as open a form, give a message box, run a query, etc.) and name it 'autoexec' and Access will run that macro each time the db is opened. To bypass the autoexec macro, you would hold down...

I think I am following your issue correctly. See if this helps: You need two separate queries: one to do the calculations and one to do the disqualifier. Then union them together. The first should sum up employee information for the quarter regardless of qualifier. The second simply retrieves...

Sure. Link the table in db1 into db2. Then refer to the linked table for your form.

I know about TransferText - i.e. creating a delimited text file with values from a table. What I want to do is have VBA create a string (I can do that) and write a text file that is the string. In other words, VB creates the string: "This is a great Access forum" and writes a text file whose...

I have a membership db that links to pictures of each family. I am trying to add some links to families whose pictures I just received and all I get is an icon, not the picture itself. I do not check the "Display as icon" box and I have checked the properties for the picture and it says to...

Thank you both for your thoughts. I was leaning towards Pat's way anyway (and I am a big Pat Hartman fan! ) One more question: how would I deal with the "infinite", i.e. the topmost price (the greatest quantity with a price breakdown - 500 in my example) would have a minimum but no...

I am trying to figure out the best way to store information. What I have is product that are priced differently at different quantity levels. I am going to want to access the information even in between the levels. In other words, let's say I'm selling frisbees and the pricing structure is: 10...