Recent content by xiong

This is hopefully a fairly straightforward question. I am building a generic search form in my application. This will allow the user to search for various records throughout the application. The one thing I cannot seem to figure out is how to allow the declaration of the TableAdapter to...

Turns out, that the problem was that I was trying to pass vbNull as a parameter for @RecordID. Passing Nothing resolved the issue. "Only the educated are free.

First off, I am relatively new to SQL Development and fairly unfamiliar with all that MS SQL server can offer. I'll try to explain as best I can what I'm attempting to do, and how I've proceeded thus far. What I'm going to attempt to produce in my application is a page that shows current...

This should be fairly simple, but the answer still eludes me. I am using pseale's mail merge method to merge my data with a few documents (faq181-5088). There are two problems I'm running into. First, I really need to suppress the warning message "Opening this document will run the following...

Is there a collection out there that I can loop through that will return the names and values of all variables in a given project? Reason: I've created a global error handler that is dumping all pertinent information into a table and log file for later reference. There are a number of public...

That's close, but I already have a list of holiday date ranges that we use for this. (dec 23 to dec 27 for 'Christmas', etc.) The main problem is that the reservations include a range as well, with only a start and finish dates. (Dec 18 to the 24th). Since in this example the reservation...

I'm looking for some ideas here. I have a table of rental reservations that include a arrival date and departure date (dtArrv, dtDepa). I need to compare this date range to another table of holiday date ranges (not single dates). If there is an overlap, I simply need to warn the user that the...

That's the point. I don't want to record a preview, only an actual print job. "Only the educated are free.

Has anyone ever come across a way to determine whether a report has been sent to a print queue as opposed to a preview? I have a dB that generally sends certain reports via email then records that function as a benchmark. Occasionally the user will need to print a hard copy instead. The...

No doubt. Unfortunately even the best laid plans are subject to the wills of the clients. These tables are already in production, and for reasons I'm still rather bummed about, I'm not going to be able to plan for the entire scope of the project in one sitting. " We need it to do this now...

That looks good for reporting on changes, but I don't see anything where it will actually make the changes to the tables if there are any. "Only the educated are free.

I have a task in front me. I have a fairly simple Access front end that links to a separate MDB containing the data tables. What I am looking to do is create a table that houses table definition data tlbName fldName fldType fldSize fldFormat The goal will be to create a function...

Yes, but the number of columns directly corresponds to the number of fields outputed. I'm looking to turn 2 fields into 4 columns. "Only the educated are free.

Has anyone every come across a way to make a listbox, combobox, or subform show multiple columns. Ideally, I'm looking for a list box that displays my data like this: Key | LName || Key | LName 122 | Johnson || 126 | Evans 123 | Hunter || 127 | Barrow 124 | Smith || 128...

It'll take me a bit to dig up, but it is possible to call the printing funtion from Access to Word (or any other of the MS Suite). I try and find an application I did a few years ago that should still work. "Only the educated are free.