Search results for query: *

I have a table with a list box for departments to be used in a query, which in turn is bound to a complex report. It works fine with a single selection but I need the users to be able to select more than one department. How can I make this happen? __________ Veni, Vidi, Visa: I came, I saw...

I have a table with computed values that have column names such as Volume1, Volume2, Volume3. Second table with the plan name, and a field indicating which volume to use (so the row may be PLAN1, Volume2) The indicator in the second table is the exact name of the column in the first table...

I have over 1000 word documents with an embedded macro defining a merge data source. The server containing the merge data is changing. Basically, the users export a data file from our mainframe system, then open the merge doc and click a button. The doc unprotects, browses out to the user's...

Recently I've decided to turn a hobby into a part-time business. I make jewelry -- hand made bracelets, necklaces, and earrings -- using Swarovski Crystal, Genuine Pearls, and other high-quality beads. I've been doing this for years, mostly for gifts and things to wear myself. I currently...

I have a macro that runs a detailed daily process -- it runs several queries to create three final output tables. Two of the tables may be empty. Once the tables are created, they are exported in Excel format. I have a condition set for those two export lines so the empty tables won't...

Is there a way to lock (or hide) a checkbox if the contents of another field is not null? On one form, I have a processing date and a delete checkbox along with other information. If the item has been processed (in which case the processing date is filled in), I want the checkbox to be...

I have a process that imports data from another source, then calculates data and compiles information based on day of the month. I want to create a "scorecard" report, but I am having a hard time creating something that is reusable. A few of the data fields for February's data are as...

I have a SQL database with a table that has over 450 fields. Access 2007 still has that nasty 255 fields per table limit, so when linking the SQL table to Access, the table is cut off after the 255th field. Is there any workaround to this? __________ Veni, Vidi, Visa: I came, I saw, I...

http://www.comcast.net/articles/news-national/20091119/US.Word.of.the.Year/ Did any regulars here have to look up 'admonish'? I find it interesting that the use of one word caused the public to search for its definition. __________ Veni, Vidi, Visa: I came, I saw, I charged it.

My sister works for a large bank and received an email this morning. I think the writer is slightly comma-happy! It was sent using three different text colors and formatted using the Comic Sans font. Definitely not a good impression from a bank manager. "Good morning, As you know, three...

I have an application where users enter information into a form. There is an existing dlookup that returns the customer name based on the customer number entered. The customer name is not stored in the table, only the customer number. This is the functioning dlookup...

I pulled this quote from my local newspaper this morning: The structure of the second sentence made my skin crawl. My first instinct was to email the writer. My second was to post it here to find out if the reporter's English is lacking or if it's just me. (-: __________ Veni, Vidi, Visa...

Is there a way to export a table into a text file with a pipe record delimiter? The table is one field wide, record count will vary. It must be exported with a pipe between the records rather than a CR/LF and I can't figure out how to accomplish this!! Any help would be greatly...

I have a table in Access 2003 that is compiled from several linked SQL tables. The access table contains records that are identified by different batch numbers. For example, the batches could be named 1201, 1202, 1203, 1204, 1205. There could be anywhere from 1 to hundreds of records for...

I know the "trim" function can strip trailing spaces from a field, but what about when I need the reverse to happen? I have a field that is 17 characters long by definition. Length of user input varies, but I need to extract the data for another program and it has to have all 17 characters...

I have a daily table that is created by a make-table query from entries into a master table, and it needs to be numbered each day starting at 1. The numbers must have 0's filling the field to 7 bytes, such as 0000001, 0000002, etc. There are usually 2-300 records in the daily table. Is...

I have a table with 110k records (just two fields) that I need to split into 5 more manageable pieces. Is there an automated way to do that? __________ It's better to have loved and lost than live with the idiot for the rest of your life.

I'm using an IF statement to verify the windows system user that is clicking a button on a form in Access. The list is going to get lengthy and would be easier to maintain in a table within the database rather than hard-code into the VBA each time there's a change. I've already created a...