Search results

Rotorque For some of the Control Wizards to work, you have to start them by first creating a control with the "Control Wizards" button depressed. This button looks like a little magic wand with what appears to have five stars. Then you click the control type you want to create. The Option...

Krava, I'm not sure what kind of join you are using but... The following SQL uses a LEFT JOIN to join two tables in a Back End db that I placed in a Front End db and it returns the records from the Back End db into the Front End db. The SQL statement was placed in a Query in the Front End...

Hi Krava, Since you have had success in accessing a single table using the method I suggested, I suspect your sql statement does not contain the proper syntax to access the second table. Since you are certain that the second table exists then, perhaps, if you will post the sql you are using...

Hi all! I think the split function is a method that was designed to take a string of data, with delimiters separating the data that will comprise the elements of the array, and creates an array of that data. The delimiters must be the same character that are used to separate each element. I...

OK Good. You might also require that the field for the disposition is filled in before closing the form Close click event If IsNull (Me.SubjectCtl) Then Msgbox "Please Fill In The Disposition!" Me.SubjectCtl.SetFocus Exit Sub End IF 'Your close code...

OK Good. You might also require that the field for the disposition is filled in before closing the form Close click event [Code] If IsNull (Me.SubjectCtl) Then

Hi Chris, I notice a difference in the number of records returned by the qry_DataEntry query (195) and the tbl_DataEntry (214) and wondered where you might be missing data. The field in the "Disposition" field in records 169, 173, ... are missing data. They must be filled in with SCR, RWK*...

If the title of your Thread "Re: Different DataSource then linked table?" implies you are trying to set the Record Source for a form, or the Row Source for a combo box, without having to use linked tables... You can set up the Record Source / Row Source, without the use of linked tables, by...

Hi Pumpkin, I'm going to take a stab at it. Your sql statement SELECT tblMechanicalFeatures.*, [General Project Information].* FROM tblMechanicalFeatures INNER JOIN [General Project Information] ON tblMechanicalFeatures.KeyNumber = [General Project Information].Key Number WHERE...

Hi Martin! If you are viewing a specific item on a form and you want to update the inventory of a that item when inventory is depleted, or inventory is added using VBA, try using... Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Set dbs =...

Regarding Primary Key and the Foreign Key objects. In my business I have seen many different Invoice Number formats on computer-generated orders from venders. For example: 1. A20595 2. 00048768 3. 175878 The vender that uses the A prefix example uses the A prefix during the first 15 days...

Hi JezLisle I decided to design your project and come up with an sql statement that would work. I created a table and took a sampling of the fields you refer to in your code. I then created tables fill the two combo boxes. You will note that I used the same names for the fields. I then created...

Thank you JAL! You are very kind. And I too feel that the forum is an excellent place to learn new and better things. I know that I have learned a lot from fellow programmers such as your self. I love access and I see that you share the excitement when we can help others who are trying to...

Jal was absolutly correct when he said... I have a table at work that I tested today. The table has 1,458,892 records with 10 fields per record. I ran my "Stepping though each record" code and the transfer of records to another table took 21 minutes 26 seconds to complete. I then ran an...

This is another method to delete a table X in database Y when running database Z and Z is used to delete the table in Y First Open database Y (The one that contains the table you want to delete) Create a module called WhateverYouLike. Not really, name it whatever you like. I named mine...

Hi, This is in reference to your "How Do You Compact A database Using VBA Use DoCmd.RunCommand acCmdCompactDatabase Richard

Hi, If you want to do a batch edit/add record I would use the following. Dim db As DAO.Database Dim rstTempUpdate As DAO.Recordset Dim rstClientData As DAO.Recordset Dim strSQL As String Dim x As Long Set db = CurrentDb Set rstTempUpdate =...

KenHigg That is what I think!

Hi, I'm not familiar with SQL servers and I may be out of my league, BUT if your form has a Record Source then you might try... If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord End If 'Your SQL statement goes here. This will make sure that all new data...

If you form has a subform then you can. 1. Place the following code in the Main Forms Current event. Private Sub Form_Current() Call ReturnLessonsAndOwing End Sub 2. Creat a Public Sub Called ReturnLessonsAndOwing Public Sub ReturnLessonsAndOwing() Dim rs As DAO.Recordset...