Search results for query: *

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.

You will need to do a requery action on the ComboBox after you have added the new Container in your RecordSource table. "Only the educated are free.

Sounds like you already have known possibilitie for your containers. Why not enter those in a seperate table then change your text box to a combo box and use the new table as the data source,, then you can limit input to what is in the table and the autocomplete is built-in. "Only the...

A do...loop function is what you are after... embedded in that will be DoCmd.GoToRecord to advanced to the next record on teh form. I would recommend using the Access code to initialize the print function as well, otherwise you may run problems if Access is opening multiple documents before...

Assuming that your Field2 values will validate as text values... Use three seperate import processes. In the first step, import the entire spreadsheet as a single table and populate the Field1 with your ID's (alter the ID by adding an alpha character (102a, 102b, 102c, etc). Then run SQL...

Sorry, after looking into it further, I realized that due to file-naming conventions in these statements and the ones like it, they prevent the user from implementing any global address and force use of only local files. Much in the same way that you can't add a grafic to a form that is located...