Search results

I rather teach you how to fish, but I was in your shoe before so attached is the fish.

don't forget to use the code tag for your VB code. [ code] ....put your VB code here so it is easier for us to read [ /code] without the space after the [ Thanks.

Try this Private Sub Command0_Click() 'need to add a reference to Microsoft Excel 11.0 (or the version you have) Object Library Dim objXls As Excel.Application Dim objWrkBk As Excel.Workbook Dim xprtFile As String xprtFile = "C:\temp\combinded.xls"...

Can you set the database to compact on close?

My 2 cents. I would probably go with Access. As you may already know, if you need to build/run reports in the long run, you will be glad everything is in a table and can be pulled by query. Besides that, your number of records will probably increase in the long run so keep them in Access will...

I'll give that a try and post what I find out. Thank you for your suggestion.

It happens too all databases; however, if I open these databases from different computer, the right click seem to work fine so I am thinking something is not setting correctly on this computer.

Thanks for the quick response. Yes, the same issue.

For some reasons, my MS Access application doesn't allow me to right click on forms, controls, tables, etc to get the properties. It appears that the right click is some how disabled. I was able to get one of my computer to work by following the instruction on one of my previous post; however...

if you are trying to display related records between your vendor and your product table for the example form you provided, all you need to do is to set the Link Child Field and Link Master Field. This should filter your data for you.

Since two tables are identical, you can probably - use a selected statement to get all the records from tblTwo - loop through your recordset and compare to tblOne to see if the StartDate of the current record falls within a date range in tblOne or EndDate falls within a date range int tblOne...

I have never done it that way, but it would be interesting to find out. I'll do some research and if I find anything, I'll post it here. Good luck on your search too.

This is an ASP page that uses mdb as back-end db. Hope it helps you a little here. <% DIM CONNECT,DBCONN,SQL 'SEARCHDBPATH is a string representing where the DB resides. CONNECT="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(SEARCHDBPATH) Set...

Is this Access or Excel?

If you only need your user to see the data, it is probably best to just run an ASP page or something and display your data using simple select statement. User will need to refresh the screen to see changes. If you need your user to actually modify data directly to the table then that's...

Depending on what the query does. If it flips a field in a table to Yes/No, then you can certainly just do do something like currentdb.execute YOUR_QUERY

Niroth, You can use the example that I have above, but modify the code to set the room number based on the room number. Private Sub OpenLazyForm(ByVal btn As CommandButton) 'take out the "cmdLazy" and only append the form number to the form name DoCmd.OpenForm "frm" &...

Just a FYI. I found this script some where, but forgot what the link is so I couldn't give credit to the author. This script appear to work for me. Private m_sSearach As String Private Sub txtCurrentText_AfterUpdate() If Nz(m_sSearch) > "" Then Me!txtCurrentText = m_sSearch...

I would probably create a sub routine to reset these comboboxes to the default state and just call that sub routine whenever I need to. Private Sub ResetComboBox() cboBox1 = "A" cboBox2 = "B" cboBox3 = "C" cboBox4 = "D" cboBox5 = "E" End Sub Peace, EZ

If the subform data are loaded based on a date range, after you updated the data, you will need to refresh the subform to get the updated data. Sorry, i haven't look at this thread for a while.