Recent content by jclu

If that's the case, and it includes (snail) mail, then credit card and line of credit offers that many times are unsolicited should be considered spam as well. You don't hear people complaining, saying "let's work toward stopping companies from sending these offers." There has to be a line...

What's the command line statement you're passing in the shorcut? Maybe if you list it here, it might help. Also, when you double-click the shortcut and the mdb is open, and you go to Tools | Security, does it show you which mdw file is being used? We have a similiar thing at my work, and the mdb...

I've been asked to modify an existing Access db, that was setup with user and group security. There is an Admins group which contains certain users. There are other user data groups which contain the users that are just entering data and viewing/printing reports. It looks like the users in the...

So in the Where condition of the macro, I could put something like [Query].[Date_Field]=[Form].[Date_Field]?

@unmarkedhelicopter: What bdhtexas is doing isn't spam! Yahoo Business Listings is a public listing, so how is it spam? Do most of us not do an equivalent when looking for a job, and we 'cold-call'? Ask any career resource center staff about how to cold-call when job-searching, and they'll tell...

Hi, I have a macro that runs a report using the OpenReport action, and has as the Where condition to display only the entries for today's date. I also have a form with a button that when clicked, runs this macro. The problem is that, while most of the time when this macro is run the filter for...

Hi, I want to write a macro to retreive information from a website and store the information in certain cells in the sheet. I've never done this before, and was wondering if it's possible to get the data from a site? I've retrieved data from websites in Java apps, and so I know that the data...

Yes ajetrumpet, it's been a while :) Thanks for the help; the code worked, but it turned out I needed to looked for BankAccount.Currency HAVING COUNT > 1.

Hi, I have a cross-ref table (called MFC_CIBC_XREF) which links a bank account to a fund number and a general ledger number. It should be a unique relationship, wherein (the "=" means corresponds/links to) Bank Account # "=" Fund # For each bank account, there are sometimes multiple currencies...

What's the difference logically in using the BeforeUpdate or AfterUpdate event? And for better or worse, if you see my last post in "help in filling in field", I decided to delete the ISO Currency Code field and the CIBC field, since they did seem for all intents and purposes to be duplicates of...

I tried the code and I'm encountering some problems. To make things simpler, since the ISO field was redundant, I got rid of it in the underlying two tables (the cross-ref table and the currency table). But the CIBC combo box isn't being update automatically. In fact, in the underlying table...

Thanks ajetrumpet! What does the Me identifier refer to - the local form/report that the code is attached to, or even more specifically the local control that the code is attached to? What about the difference between using the dot/period (.) and exclamation mark (!) - what do each of them signify?

I see your point; I think I'm hesitant to delete the field because I didn't originally design and set up the database. The db is actually part of a process to take a csv file of financial txs on certain bank accounts (the txs are posted by the bank itself), and then upload them into the ledger...

Thanks for all the help to those who have answered my question! Please excuse the fact that I've been asking questions and not really answering any, but currently I'm more a beginner when it comes to the advanced stuff in access, such as creating vb modules and sql statements to do more than the...

To make it easier on the user, I've created a form that pops up when the db is opened, and contains buttons that link to the other form/commands. This form also has a Quit button, and each of the other forms have Exit buttons which close that form, the idea being to bring the user back to the...