Search results

My database for chemical inventories has a lot of data on the main form and then I added an number of checkboxes which had to go onto another form which I made as a popup form. I have the popup form syncronized with the main form through a Record Source query with criteria linked by InventoryID...

I noticed that also. Access 2K doesn't have the PopUp property for reports. What version of Access are you using, gold007eye? Is there an alternate way to make a report into a PopUp or equivelant for Access 2K? I do like your non-API method of hiding the database window. Thanks, PC PS...

Thanks for the discussion. I'll have to try your method for my reports. As for forms, I don't open and close them. Instead, I design my forms to swap subforms and I use multiple subforms. See this example Thanks, PC

That's a good point about clarifying terminology. The website "The Access Web" at http://www.mvps.org/access/api/api0019.htm uses the term "The Main Access Window." I use the code from this site to show only the active form, but is cumbersome to figure out how to effectively do a report...

Thanks for your reply. When I close the form for the report to appear, it works. However, when I try to get the form to return to its previous state, the API module (hide/show access window) doesn't handle the form right. Have you seen a sample of the correct handling of the API module when...

I have a question about using the API hide access window module. This works ok for my forms, but the report preview window always gets hidden or shows up behind the form. How can I use this module and have the preview reports in front of the form? Thanks, PC

I seem to remember this is a mathmatical operation done in matrix algebra. This an advanced mathmatical technique that I learned as a prerequisite for finite element analysis. I like to see how bvan's use of it in a database. ~~ PC

I couldn't get the loop to work, so I decided to do it the long way to get it to work even after using Debug.Print Me("Filter" & intCounter).RowSource to find the problem. Me.Filter1.RowSource = gstrRowSource1 Me.Filter2.RowSource = gstrRowSource2...

Thanks for your reply. That command line works ok. Its the loop syntax that I think has a problem. The command line to which you are referring is out of the loop. Thanks, PC

I'm having trouble with my loop counter. Its not setting the rowsource for my combobox filters. The strings with the "gstr...." are global variables. I think there's something wrong with the counter for the gstrRowSource, but I don't know how to correct it. Private Function SetFilters()...

DreamMail V4.2 works well with Hotmail, Yahoo Mail and MSN Mail. http://dreammail.europe.free.fr/index.php?page=home&lang=en There are a few other email programs that also do this. http://www.portablefreeware.com/?q=email Good Luck, PC

Send & Receive Hotmail Through Access I see a number of methods to send & receive emails through Outlook, but I'm more interested in using my Hotmail account. Does anyone know how to interface Access 2K with Hotmail? Regular email programs that work with Hotmail don't use pop3 or smtp...

I'm using the voice reader from a db demo that I made and putting it into a db that has richtext. I'm made a public function that reads the text; however, when it reads richtext it reads all the format codes as well as the content text. I need to be able to have it read the text of the...

Thanks very much. You've found the source of the error. PC

I found this very useful function on the internet and I'm trying to get it to work. I keep getting an error, but it appears that the code is correct. Can anyone else get to cycle through a table and change the properties of all text and memo fields?'************************************** '...

That's an interesting and useful utility. Thanks for showing it to me. It has some interesting concepts. I'll continue looking for a solution. Thanks, PC

This public function works in the backend, but the command to minimize on view and maximize the form infront of the report on exit doesn't work. I had to set a reference to a backend seperate from the data backend with the reports with it. I put a command button on the form on the FE to call...

Ok. I got a little hint about how to do it, but I need some more help with this. Public Function MyOpenReport( _ strName As String, _ Optional strWhere As String = "") DoCmd.OpenReport strName, acViewPreview, _ WhereCondition:=strWhere MyOpenReport =...

Is there a way to store reports on the backend of a split database and still use them on the frontend? I also need to read from the MSysObjects that is on the backend without linking to it. Thanks, PC

Ok! That did it. Thanks very much. I added the WHERE clause and now it works. strSelect = "SELECT * " strFrom = "FROM qsubSearchCurrentWorkOrders " strOrder = "ORDER BY " & col & " " & xorder If Not IsNull(Forms("frmMainEntry").Form.Controls("cboWOStatus")) Then...