Search results

Hello, I have the Access window hidden, to do so the form I use has it's Popup set to yes and this seems to disable the copy and past function, i.e when you right click the mouse the menu dose not appear that give's you the option to cut, copy and past. Dose any one know if it is possible to get...

Hello, has anyone seen or have a link to or now how to make a transparent form that show the text from a text box. I have found various code for a transparent form but you can not display text on it, which I need to do, i.e I need to place text boxes on a transparent form and have only the text...

Hello, I would like to size the Access window to be in proportion to what ever form I have open, I know how to size forms with code, but not the window. Thanks

Hello, Is it possible to have only a form showing and nothing else off Access visible using 2003, tried with the stuff in the tool section, but if possible could not get it to happen. Thanks

Hello, I have a table( about 11,000 Entries) with insurance info. It can some times happen I will have entries like so: Id Payor Position Insurance aaaa 1 ZRB aaaa 2 MA aaaa 3 MA I need to delete the...

Hello, I have a crystal report which I imported into Access, the table is like so ID Insurance Name ID1 Ins1 Name1 ID1 Ins2 Name1 ID1 Ins3 Name1 ID2 Ins1 Name2 ID3 Ins1 Name3 ID3 Ins2 Name3 ID3 Ins3 Name3 ID3...

Hello, the code below run but will not compile, I get Me.RecordsetClone() method or data member not found, is this a library issue?, or improper coding, I can't seem to figure it out, any insight is appreciated, thanks Dim recClone As Recordset Set recClone = If Me.NewRecord Then...

O.k this seems bazaar to me, I have the below code were qryADO is a query like so: SELECT * parse(field1) then make table. I made the query in GUI so works fine. When I execute the code below it takes 2 minutes for the table to show up, but if I go to deign mode the table shows up immediately...

Good evening, just getting my feet wet with ADO, not tired updating from sql before. Assume There is s connection then if Dim rs As New ADODB.Recordset SQL = "SELECT * FROM tblCustomers ZSQL = " Stuff " rs.CursorType = adOpenDynamic rs.LockType = adLockOptimistic rs.Open SQL, , ...

Good Morning, I have written the two functions below but they cant be used together, one is a validation function the other is a clearing function, if I place a c and v in the tag proprty box they are both ignored I tried changing one to I as Integer and placing a 1 in the tag box but did not...

Good morning, in connecting with ADO is there a preferred method a) Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection b) Dim cnn As ADODB.Connection With cnn .Provider = "Microsoft.Jet.OLEDB.4.0" .Open "MyPath\MyDatabaseName.mdb" or a third method ? any...

Hello, I am tiring to write a (more or less) all purpose validation code, what I have so far works except for one thing, if there are multiple controls needing validation and you execute a command with out entering data the focus will move to the next control failing validation and so forth...

Hello, I have a parsing function which parse's with respect to a comma. If I go in to the module and change where the comma is declared and change it to a . then it will parse w.r.t a period similarly for a space or tab. So know I have three modules to parse three different ways. This is for a...

I cobbled together my first function two days ago(with help from the form) Function ClearAll(c As String, f As Form) Dim ctl As Control For Each ctl In f.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox If ctl.ControlSource = "" And ctl.Tag <> c Then...

Hello, I am tring to code my first generalized function, I have(which works as a function on a form) Function ClearAll(c As String) Dim ctl As Control For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox If ctl.ControlSource = "" And ctl.Tag...

Hello, I am making a parts order form and I need to get the max value from three fields MSRP MarkUp HcpcPricing On MS web site they have a verbose solution, Would love to have a more succinct one if anyone has it . Thanks

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

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...

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...