Search results for query: *

I had originally posted a topic at the following thread for assistance however this won't work. http://www.tek-tips.com/viewthread.cfm?qid=1202945&page=2 To me the same concept applies however, I am only working with one table now. I have a ticket table that contains ticket information for...

Sorry for the length. Background I have a ticketing database that contains all of my forms, queries and a couple of non-linked tables and many linked tables. The primary tables are in a separate database. The "forms" database is compiled into MDE's and placed on two workstations, where the...

I am working with FAQ http://www.tek-tips.com/faqs.cfm?fid=5263 to override wheelmouse movement so it does not add blank records to my tables. The program I am working on is driven by Switchboards. How can I incorporate this by placing the ENUM statement in a module? Ascent

When controls are tabbed all the way through a form with bound controls it automatically adds the record to the table. Is there a way to prevent this? It is placing an invalid record in a table and I would like to prevent this from happening. Ascent

to make things work faster. I need some assistance to see if I can make this bit of code faster with another approach. 'Recalc reorder levels. Dim intTotPreviousTwelveMonths As Integer Dim rs As DAO.Recordset Dim db As DAO.Database Set db = CurrentDb Set rs =...

Is there a way, or does some have a way to print table structures within an Access database? Ascent

I am have problems with the (((tblBMtk.[MATERIAL-CODE-1])=[forms]![frmReOrderLevels]![cboMaterialCode])) AND ((tblBMtk.[ORDER-DATE]) Between DateAdd(""yyyy"",-1,Now()) And Now()))) of the code. Can anyone help me sort this mess out? I need the contents of a combo box to equal the field...

I have a created a recordsetclone of the data source of the form I am working on and it will not give me the .findfirst method. The following is my code. Dim rs As Recordset Set rs = Me.RecordsetClone rs.FindFirst = "[Material] =" & """ & cboMaterialCode & """ I have used this...

to lock the column widths in place on a subform so that the user cannot increase them, thus causing scroll bars to appear?

I had the following code working correctly, but I am not sure what changed .FindFirst "[UPC] = " & rsClone!UPC It was previously giving me [UPC] = 123456 the code is not give me "[UPC] = 123456" when it does the search. Thus it failes because [UPC] in tblUPC is a number field. Thoughts or...

I am looking for a function in VBA that will check to see if the results of a calculation is between a range. I cannot seem to locate anything in the help file or from searches on the forumn. Any suggestions other than the x > y and x < z approach?

On my form I have 10 command buttons that delete the contents of the text boxes following them. Each control is named delete1, delete2,...delete10. In a Public function that is called from another control i verify some data and then if needed prompt the user to delete this "line". If they say...

My predecessor created a well-to-do ticketing program. His hindsight and lack of real world knowledge has left me in a bit of a jam. The department that uses this program receives updated inventory counts once a week. (The night that their tickets are billed as invoices.) It has been a long...

I want to use an append query to compare to identical tables and then append the "new" records to the "first" table. I assume I will have to create a select query and then run my append from it, but I am not sure how to start. Thoughts or suggestions would be appreciated.

Is there a way to use the Selection method to change the BackColor for a selection of cells? Range("k9:p38").Select Selection.BackColor = &H80000005 I thought the above might work, but I get the following error: Run-time error '438' Object does not support this property or method. Ascent

I have stored some formatted text to a string variable and am then assigning that variable to a textbox for display on a form. (It's the only control on the form.) The only signifcant formatting I have is carriage returns. The displayed results is a bunch of senteneces running together. Is...

I have a previously existing program that I have been charge with "ID 10 T" proofing. In this last week things that had originally worked seem to be not working. Background: A form is bound to a table. The txtBoxes are bound to the control source of the form. Example: When the Exit/Delete...

Good day everyone, I made some changes to a subform that is linked to the results of a combo box. All I did on the subform was add a few fields and changed the tab index for layout purposes. After saving my work, I was able to view a few examples and take a screenshot so I could send it to an...

I have a simple Excel spreadsheet that contains 10 comboboxes. In the Change Event, I test the value to find out what cells will be copied and pasted into another portion of the worksheet. The "people" using this sheet would like to proctect the sheet, but doing so kills the copy and paste code...

I am having a pathetically hard time formatting a Control Toolbox Combobox. I can get my list of values to display in it, but in order to see the values the FIRST time through I have to click on up or down "arrows", the kind you normally see in listboxes. The second time I click on the...