Search results

Yeah, your example works for the subreport and where the subreport breaks on pages, but if the subreport itself is positioned on the main report in such a way that part of the subreport control falls to a new page, it still breaks when you print the main report. For instance, I have a subreport...

[SOLVED] Load a form/report dynamically with tempvars Hey folks... is there a way to code a button that will load a form or report, but have the form or report's name saved in a TempVar? For example, have a button on Form1 that loads either Form2 or Form3, depending on which form's name is...

The.... subreport's detail section, or the primary? I just figured out that I can put a page-break control in the detail section of the subreport and that seems to work for me (the photos show on a new page if there isn't room on the first one, and if there are no photos, I only get one page...

Hi folks. I have a report that has several subreports on it to display nested records. The report is rptReport, and I have sbrptPeople and sbrptPictures. The sbrptPeople is a continuous report of a list of people that match some search criteria, and sbrptPhotos is much of the same, except it...

I like this solution, it seems simple, but I think it might not give me the result I'm looking for, because when users make use of this search form, they may very well get a list of results, all of which match the search criteria. For instance, using that vehicle example, a user might go in and...

Okay, your database system needs some design tweaks, because your AVLOG_Frm has multiple possible records into which to write data. You'll have to have a way on your previous form, the EmpSearch_Frm, to select a specific record in your table. Then I'd use an Insert Into query statement to set...

Yes, that's probably correct. You asked specifically how to get info from one form to forward to another form when you click a button, and I've shown you how to do that. From your comment, it seems as though you're looking for more in-depth programming to get the data to enter into a table, as...

Yes, it does work. I just downloaded it and checked it myself. Download the attachment, double click the EmpSearch_Frm to open it, and select an employee (or search for one). Then simply click the button below that employee, and the other form opens and loads that employee's info into the top...

Okay, here you go. I've done two things: 1. I created an embedded macro behind that button on the EmpSearch_Frm that sets your TempVars on click and then opens the AVLOG_Frm 2. I set the fields on AVLOG_Frm to fetch those TempVars and set them as the default values in the fields (I didn't...

This is a great module that works wonderful, but I wanted to let people know you can do the version checking without using VBA, and simply have an Updater application that runs the VBA to delete your local copy and download the fresh version off the server. I use a table called AppConstants on...

What I would do is on the OnClick event of the row, store the field's value into a TempVar When you click the button, add some code to the OnClick of the button that runs a SetValue command on the field you want to insert that value from before. I use Access's Macro to do this, but you can...

Another way to do this (which I do often) is to set your field values to TempVars or LocalVars when you perform the action that opens the subsequent form, and then immediately set the focus to the second form and run SetValue actions to set those TempVars into the respective fields.

Yep, probably a join issue. I tried several different types of joins in several other threads on this topic (check out my started threads history and you'll see how long I've been fighting with this). Let's say I have a PEOPLE table, a CARS table and a PETS table, and all three are linked with...

Yes. Create a query based on your table (the table that's linked to that excel sheet) and view the query in SQL. It should say SELECT tailNumber FROM tblMyTable ... etc etc etc. Add the word DISTINCT after the word SELECT so that it says SELECT DISTINCT tailNumber etc... (obviously your...

Yeah, that's the search criteria I use in the query for each field, and it works exactly as you said. But my issue was that when I have TWO tables in that query and I leave all the search fields that are linked to ONE of those tables blank, it returns NO records for that table instead of ALL...

Unfortunately that would be more trouble than it's worth. It has a LOT of data in it right now (like almost two gigs... i'm not joking... this thing has been in use a loooooooong time) and it's a split database with lots of VB code, so even if I were to copy the remote tables and paste them as...

Re: Yet another issue with LIKE OR IS NULL [SOLVED] I know this thread is really old, but I wanted to post that I figured out how to get this query to work. Short answer: you can't get ONE query to do this for you, you have to write SEVERAL, one for each combination of the tables that may...

Hi folks, I have a really REALLY old database mdb with an OLE field, and I'm moving the records from that old system to a sparkly new system with an attachment field. How do I write the query to fetch those old OLE objects and move them into a new table's attachment field? I tried using an...

Thanks, Isskint, that sounds like it would work for externally stored images, but my logo image is in the table itself, and not stored externally. I use Access' attachment dialogue to allow the user to attach an image to another form (frmSetup), and that attachment is stored in the table. I...

Hi folks. I have two tables, tblAdmin (which contains my attachment field, a logo) and tblRecords (which contains customer records. I created a form (frmMain) that displays customer records, and hooked frmMain to qrySelectCustomer, which is a query that... you guessed it!... selects a...