Search results

They are 10, 5, 0

I really don't know of a better way to word it. Basically, the table with the data I'm trying to create the lookup value for has three columns, ReportID, Report_Name, and Years. I want to be able to not only use the ReportID to pull the Report name, but also use the years for a query I've got...

I have two tables one with all the personnel (tblPersonnel) I'm tracking, another with different report names (tblReports). For each report, there are different years that it's valid for. On the reports table, I have three columns, ReportID, Report_Title, and Years_Valid I'm using a...

I figured it out, but I put it in the OnCurrent instead. I've been running on 4 hours of sleep and a pot of coffee, so the wheels weren't spinning as fast as they could have.

Is there a way to remove data from one or multiple fields if the value of a separate field IsNotNull?

I'm using a macro (I know) for opening the other form with a WHERE clause for matching the ID in the record to the ID in the sub-form. Only problem is, like I said before, not everyone has a record in the second form. I'm guessing I'd need to make a tempvar for the second form to store the...

I've got a main form (frmPersonnel) with the the record ID as a clickable action. When a user clicks on the ID, another form opens where they can add specific information for that record alone. I have two tables (tblPersonnel and tblLocalInfo) that are linked via relationships. Everything...

Kyoch, have you tried using a continuous form?

Ok, I was able to enable it this morning. My question is, sense I'm not too familiar with the ADO reference, will it work on any computer now or will I have to enable it on every computer that uses this database?

We have a very restrictive network. I'll try again in the morning, but I had no luck today. CJ_London: From what I could see today, yes. I didn't have the option to add it or any other add-in for that matter.

Yes. I imagine it won't take long to have a bunch of label sheets with the first two or three labels missing.

I've got a report that spits out a barcoded label for items on my inventory. What I'd like to know, is if there is a way in 2010 to allow the user to select where on the page for the label to print. I found a way that looks like it worked for 2007, but it required enabling ADO, which I am...

I could do that, but that's not what I'm wanting. I've even tried the following: DoCmd.OpenQuery "qryInventoryActive" DoCmd.RunSQL "SELECT *, FROM tblInventory WHERE [Owner] = " & DEPARTMENT H & "" EDIT: Figured it out, but man does my head hurt now.

I've searched all over for this, and I know as soon as I post it, I'll find the answer somewhere, but I need your help! I've got a database that's a monster. It has at least 15 different queries, and I want to simplify it by doing away with these queries and using code to generate the queries...

Just to clarify, this is what I have so far. Me.RecordSource = "SELECT * FROM qryInventoryActive" Dim strMsg As String Dim strInput As String strMsg = "Which Case?" strInput = InputBox(Prompt:=strMsg) DoCmd.ApplyFilter , [CASE] = strInput This doesn't return an error, but it also...

Going to need a little more information than that.

I'm trying to write the code for this, but VBA is just not something I'm 100% familiar with yet. I want to create a filter that asks the user for input. I want the results restricted to just one column (so it won't filter down to anything containing the user's search string). Once it...

I think I've got it figured out, thank you for your help!

I've got an update query that will be ran to update a field. That part is simple enough. What I want to do is prompt the user on whether or not they want to generate a report based on the update query. How would I go about implementing that?

Paul, You previously helped me on my last database. I'm using the same one as the springboard for this new database, I'm just stuck on my tables and what needs to go where (this was over a year ago and I've had so much crammed in my brain since then, I don't remember :)). I'll attach that...