Search results

Yup it does. It works perfectly fine if you just click it on the form (on it's own.) The problem starts when that form becomes a pop up window of another form. The combo box no longer works and I just cannot figure out why. I tried changing "Me.Recordset.clone" to "Forms!XXX! Recordset. clone"...

Hi, I have created a typical form (Form A) that shows data from a table. I also created a combo box within the form that searches for records. Within the form itself, it searches and display the record smoothly. I created another form (Form B), showing all details of another table, inclusive...

Thanks guys! I will try it out again today and hope it works. Thanks!!!

Hi, I have created a database with 30 users in mind. I used the "Database spiltter" in Access 2003 to spilt my database. I have also changed my open option in the advanced tab to "Shared" before sending the front-end to my users. The problem is that all my users still have the message saying...

I'm a VBA idiot, can you please teach me how to do it?

hmm.... I dun think a timer will work as it is supposed to run the macro based on system time, not time length. I need the macro to run when the time is 1400hrs and 1800 hrs.

Oh, On my form, i need to show a few different time zone for a few countries. That's all

My company uses a corporate license for MS office, it should not be of any license problem if multiple users uses the same database at the same time. I'm just worried that different users logging in and updating different table will cause the database to malfunction. Moreover, I do not have...

Hi, I been trying to make my database updates certain tables on a few specific times on the day. (e,g 2pm and 6pm) I tried using a Do while loop (which hangs the entire database) and Dlookup (which did not work) without much success. Can someone kindly enlighten me please?

Well, I don't think so. The database will later be uploaded on the net. I do hope that the time function will not take up too much resources.

Thanks for your help! There will not be any need to worry about computer resources as this database will be running on a server.

Is there anyway that I can display date and time (that is running) on an access form. The time() function only shows the current time and freezes.

Must it really be placed at the back end? Is it possible that everything is accessed through the server? (All local PC with act as a dummy computer) Do I need to do the same thing if I were to publish the database on the web?

Hi, I need to allow my MDB to have 15 users accessing at the same time. They will be updating different parts of the same table using different forms. The system will also do an automatic update from another system in 15 mins interval. Is it possible? If so, how do I configure my access...

I have found the mistake. Silly me!! it is the name of the form that is wrong. Thanks for your help bob!!!

Hi, the system gave me an error, stating that the form cannot be found. I have counter check the form name and it is correct. Here is the code again. (I renamed a few parts) Dim strMsg As String, strTitle As String Dim intStyle As Integer Dim strDocName As String, strLinkCriteria...

Hi, I have been trying to create a popup window that show information of two different form. Both form have the same primary key. I tried using the same code in Northwind (In "Suppliers" Form) but with not much success. the code that I copied was: Private Sub ReviewProducts_Click() Dim...