Search results for query: *

All, Have the following code: Private Sub cboBoxNum_AfterUpdate() Dim strSQLSF As String Dim TowerX As Integer Dim BoxX As Integer TowerX = Me.cboTower.Value BoxX = Me.cboBoxNum.Value strSQLSF = " SELECT * FROM tblBoxSlot " strSQLSF = strSQLSF & " WHERE tblBoxSlot.Tower = TowerX And "...

Hi, I have a table say tblBoxSlot With the fields:box, tower, and slot1, slot2, ......slot81 Empty slots have a value of -1111 Filled slots have a value of an integer greater than zero. How can I find say the first 6 consecutive slots in a box record that are empty (-1111)? I am having...

Hi, I have created a form in which I assign a image to a unbound image field based upon the following code that has a field on the form that contains the path to the image. In the past I have used this on a single form and in the on current event. However, I need this in a subform that is...

Hi, I have created a form in which I assign a image to a unbound image field based upon the following code that has a field on the form that contains the path to the image. In the past I have used this on a single form and in the on current event. However, I need this in a subform that is...

I am trying to complete a Do Loop sequence that includes a recordset findnext command. Unfortunately, the Findnext always stays at the last found record (it successfully finds the previous records) instead of return a EOF is true which would end the loop. Any hints would be greatly appreciated...

I've tried the following stub code (you can see some commented out tries) but I cannot get to the first cell in the table and then move between cells. Private Sub MergeButton_Click() Dim Letterloc As String Dim strInsured As String strInsured = Me.txtInsuredName Dim db As DAO.Database Dim...

Hi, Have used book marks in the past to do a mail merge for a single record into a word template. Works great. However, I am now faced with moving through a record set (using finds) and for a particular vendor listing once their name address, etc. Still works great with book marks...

Hi, Have used book marks in the past to do a mail merge for a single record into a word temple. Works great. However, I am now faced with moving through a record set (using finds) and for a particular vendor listing once their name address, etc. Still works great with book marks. However...

I need to be able to duplicate a record on a form and create a new record. In addition, the same procedure needs to copy the existing subform records (a couple of different subforms are on the form) as well. The new subform records obviously need to point the new duplicated main form (think of...

I have a form that uses an autonumber field for its primary key. I'd like to calculate a transaction code utilizing the autonumber field and some other parameters and assign that transaction code to a field before the user moves to a next record. Is there a way to determine the autonumber...

I am fairly new to access but have coded a little VBA code so far. My need is beyound my skills at this point. I have a form with beginning and ending date fields linked to a query (A). I need to have a cmd button that would kick off code to insert records into another table (Table B) for...

I have a continous subform. On the subform I have a command button with the following code. It fails. Obviously I am missing something. 'DoCmd.OpenForm "frmRooms", , , "[RecID] = '" & Me.RoomID & "'" frmRooms is a form to open, RecID is the frmRooms field to search on and Me.RoomID is my...

All, Searched the archives but no joy. Anyway I have a command button that executes the following code (basically picking a file and location and assigning it to the txtDocLocation fiedl). Me![txtDocLocation] = GetOpenFile_CLT("C:\", "Select Document Location") Me![txtDocLocation] =...

I have a form subform combination. I need to do a Dlookup to populate a field QuickenCode in the subform. I am executing the following in an after update event on the field ExpenseCodeID in the Subform. It fails on syntax. I inherited the table and form IDs with the spaces in the name (ugh)...

I set a global variable based upon an employee logging into the system. I need to execute a form based upon a query. However, I need to limit the query results to the value of the global variable. How do I set the query criteria to the global variable so I only return the appropriate...

All Seasons Greetings, Fairly new to Access. I need to populate a combo box with a selection of dates (every Saturday from 1/1/2004). Is there a function or query I can build to do this? The second question is I would then like to populate 7 records in a subform with the dates of the week...

All, The following code is part of a button command on a sign-in form. In addition to the password routine I need to count the connects to the backend DB. Before I write the connects test routine I have tested just looking at the number of connects. When the form is first opened (MODAL POPUP)...

All, The following code is part of a button command on a sign-in form. In addition to the password routine I need to count the connects to the backend DB. Before I write the connects test routine I have tested just looking at the number of connects. When the form is first opened (MODAL POPUP)...

I've seen some code to check the number and id's of users logged into a database. Is there an equivalent or better way to check who has linked to a database?? Thanks for any help.

I've searched the forums but have been unable to find ideas or code on the best way to limit the number of users accessing a database. The database is split with back-end networked tables. The organization does not want to use the Access security model just limit say three concurrent users. Ideas?