Search results for query: *

I'm wondering what the best way to do this would be: I am trying some stuff out and have a server with 2 databases on it, Live and Test. Basically I want to pick a connection on the first form that gets used throughout the program until it is closed. Everytime you run the program, you have to...

I have searched high and low on the Google and have not found a suitable answer. It seems that no matter what theme I choose, even my customized ones, the color that it actually uses on my form is not the one I picked - they all seem to be a lighter variation. For example - if I tell it I want...

Hey all, I'm trying to present my form to my users that look like an excel form (data sheet view). My problem is that it is a non-updateable query due to a Left Join on one of the 3 tables. The table layout is like -------- ------------- -------------- tblHours <--- tblClientInfo...

I have the forms and everything built out, but am looking for a way to do copy a row from an Orders(tblOrders) table along with it's Order Details(tblOrderDetails) and insert them back in. The only catch is that I only need to do this to any order detail record that meets certain criteria. For...

Not sure if this is for the query area or not...but here is my issue: Simply put, I need to compare numbers from 2 different rows. If one number is less than a set value, then a flag should go up, same with the number from the 2nd row...if it is less than a specified value, then the flag is...

I'm looking for any advice on doing an attendance form that's easy for the end user. I would like it to have a grid/excel feel to it since that is what they are used to. I was thinking of having a form populate a list of people who are enrolled in the program and then entering 3 items...

I've read through a bunch of posts on this site and others and am still coming up with no luck. As other people have noticed, I need to print one label at a time on an Avery 4013 (3 1/2" by 15/16" size of 5000 continuous labels) using a report. It's being printed ona 24 pin dot matrix panasonic...

Hey all, I have this piece of code that I put together that loops through a recordset of emails and changes the reports querydefs WHERE clause on each loop for the particular user. It works and sends out the correct report with the correct info...I'm just looking to do 2 things: 1. I'm not the...

I need someone to point me in the right direction possibly here. I have a 2 column combo box that holds the the value(ProgramID), but shows the name (ProgramName). It's row source is to select from the programlist table the ID and Name only where Available = True. That way the user can only...

Hey all, I need some help when it comes to handling a click event for a series of buttons that are created dynamically from XML. I have a LoadXML method that creates rows for the buttons and names them with the "name" tag from the xml. Is what I'm trying to do is have their click event open a...

I've read a few posts where people build their query string in access via the code and then send that over to get the results. Is that the best way or is it better to come up with a stored procedure in SQL to handle that. I guess is what I'm looking for is if I have an unbound form with a...

Hey all, I have a select statement that I'm using in a query column to return the smallest date using the Min function. The problem I'm running into is I need NULL to be the "smallest" value. For example I have this query: MinEndDate: (SELECT Min(EndDate) FROM tblPlacementData b WHERE...

I looked at the other thread about late binding and decided to start a new thread. How ever I try to do late binding, I get the error object doesn't support this property or method. and it all starts at the .MeetingStatus line. Even if I comment that line out, it will have the same error on the...

Is it a problem to have relationships set like the following: Table1 has it's own ID PK field (we'll call it T1ID) Table2 has it's PK field T2ID and the FK of T1ID That's the normal stuff, but is it wrong to have another table: Table3 has PK T3ID and two FK T2ID and T3ID I guess why I ask is...

Has anyone ever tried populating a date field on a form when a certain key is pressed. For example, if I press "t", then it puts in today's date. I have a way to do it, but I don't like it and I'm looking for advice to better this. Here is the code the form field calls: Private Sub...

Hello all! I'm looking for any ideas on the following: I have a query that pulls in Date, Wage, and Staff from a query. There is input parameters, [Starting Date] and [Ending Date], on the Date field. This report will be pulled usually by the first of the year, ie 1/1/2008 to the end of...

I have a table with about 40-50 fields on it, the majority of them just enter yes or no for the text on it. I'm trying to figure out how to get the same kind of output that a CountIf does in Excel. Do I have to create a report based of that table and add in a text box for each field that does a...

Can anyone point me in the right direction here...> I have a gridview that grabs CategoryID(int), VendorID(int), LoadOS(bit), and Addressable(bit) from my SQLDataSource. I am trying to filter based off of those fields using seperate dropdown/checkbox controls called ddlCategory, ddlVendor...

Hello, can anyone get me started on how to pull all login/user names from AD in a combo box? It's either something of this solution or create a table w/ all of our employees (which seems like a not so good idea if that info is already in AD). I'm guessing it would be a public function or...

Here's a little piece of code that looks for the date of birth (DOB) on the form and displays a label saying Happy Birthday if it is, otherwise hides it if not. Feel free to modify - I just find it neat. Private Sub Form_Current() Dim dteBD As Date Dim dteToday As Date Me.lblHappyBDay.Visible...