Search results

This code or built in function is used in a form I found by googling : fEnableNextInTab() I tried googling its meaning and how to use it, nothing at all clear came up. If any one could give me some insight on it I would appriciate it. Thanks

Thank you Missingling, I did not know any of that

That did it Mr B, thank you

Hello, I have a bound form with navigation buttons, user's want to delete records, have the following code, but keep getting aplication defind error and #### marks in controls(Deletion dose work), these go away if I refresh but form dose not execute refresh code, must do manualy. any ideas...

The perfect solution, Thanks- theAceMan1, where yourTableName is a table of your picture names, not a table of pictures. In the forms On Current event copy/paste the following: Dim db As DAO.Database, rst As DAO.Recordset, Pth As String Set db = CurrentDb Set rst =...

Hello. I have a switch board(Not made with wizard)it has a picture on it, would very much like for picture to change when switch board is opened. Private Sub Form_Current() Dim path As String 'The Me.Filename is the name of a text box that holds the filename. As you change records if you...

Hello, I have a form, sales staff use for spects to build a demo wheel chair, they complete and they save it. 5 minutes later they go wait I don't need that. It needs to be deleted. This is not a problem. But form, on save has set Status = "Committed" Storage = "OUT" Adding this back in is...

I will play with your explanation also with the docmd advice, again thanks for all the help

SOS, I have form called Build Sheet, sales staff use it to set spects for wheel chairs to be used as demo's (which customer then use, so they know when time to purchase they are getting the right one as they can cost upward of $45,000.) All I want to do is navigate through my saved Build Sheet...

SOS, thank you for your reply, at the time of witting I was reading a access book w/vba and I was not following the discussion. Since, I have , kind off, sorta, some what got a fledgling understanding of this. I made a simple form with 3 cmd buttons and place this under one of them Private...

Hello, I am reading my Access book with vba and the topic is ADO and I am "learning" the following Dim cnnX As ADODB.Connection Set cnnX = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnnX myRecordSet.Open SQLstatement ' cnnX = variable that...

OH man, you saved my day with that bit of help, Thanks. Tim

After working dozens of hours building a from that builds sql statement to make union quires, I discover that DoCmd****nSQL (SQL_Text), Dose not support SELECT statements (sigh). Can some one tell me if it is possible to use a insert query to insert a table into another table if the fields...

Thanks evey one for your reponces. I have a form I am working on that builds an sql statement, the first part is to change the field names in one table so they match those of a differnt table. Then select those fields whose name has been changed and Union them to the table with the field...

It clears the controls on my form, which is what I want it to do, the one's "taged" *, I need to have a default value, but everything clears. Also I am trying to understand the tag property. New at this as you can tell. Tim

Can some one please tell me what I am doing incorrectly, the ElseIf is working But not the If. Thanks Tim Sub ClearFormText(frm As Form) Dim ctl As Control For Each ctl In frm.Controls If ctl.ControlType = acTextBox And ctl.Tag = "*" Then If ctl.Name = "txtNewField" Or ctl.Name =...

Turns out Access dose not support RENAME, I found this on another fourm, works well Sub RenameField(strTableName As String, _ strFieldFrom As String, _ strFieldTo As String) Dim dbs As DAO.Database Dim tDef As...

Thanks again, I'll give it a try.

Thank you rainman89. Rainman89 if I have more then one column is it ALTER TABLE mytable RENAME COLUMN mycolumn1, mycolumn2 TO new1, new2 Or ALTER TABLE mytable RENAME COLUMN mycolumn1 TO new, RENAME COLUMN mycolumn2 TO new2

New to writing sql. From my books and on line search this seems like it would work. ALTER TABLE tblparts1 CHANGE HCPCRow1 Hcpc get syntac error, CHANGE , have tried: change Column, Modify, no luck. Would some one tell me the proper statment. Thanks Tim