Search results

Hi All, Hopefully a quick one... I'm trying to reference a subform object when i change a combo box value. I want to set the text box on a subform to disabled if the combo is blank. something like.. Me.subform.textbox.enabled = false ..but this isn;t working as the object 'textbox' doesn't...

Ok, i've kind of answered my own question. I've used an unbound object frame to insert my chart. Problem is now is that the image is really distorted/unclear. Is there a way to have it displayed exactly as it is in the workbook?? Thanks.

Hi all, Just a quickie (i hope) Can i display an excel chart in an access form (2003)?? If so, how?? Many Thanks.

unfortunatley exactly the same. I think i might have to put up with it. I've tried a few different things and no results.

Hi, i have a form which has a label on and behind it is a a rectangle (with background solid). I am using the 'on mouse move' event of both to create a hover effect on the label. Problem i'm having is that when i move over the rectangle the label flickers a lot. Is there a way to prevent...

spot on. Thankyou. :)

Hi All, Can anyone tell me if it's possble to hide entire form groups from VBA. I have several controls on a form which i have grouped. I want to be able to use something like : form.group.visible = false/true Otherwise i'll have to do each control which is a bit of a time burner. Many Thanks.

Hi All, I have resorted to having a dynamic list box workling from a crosstab (as a crosstab to subform seems undo-able). My new problem is this... I want to be able to set the first two column widths of the list box after i have set the new rowsource. Thing is, i only want to have to...

I guess dynamically changing a subform can't be done. My next question then.... Is there a way i can create a subform on the fly and set it's recordsource so that all the columns are added??? thanks

Thanks for your swift reply Dennisk. Both my columns and rows change each time a search is performed. I now have this code which i think almost works but won;t set the subform to the new tables data..... DoCmd.SetWarnings False Me.sFrm_Skills_Lookup.SourceObject = "" DoCmd.RunMacro...

Hi All, I am trying to set a subform based on a crosstab which a has variable rows and columns based on some form combo boxes. I have got to the stage where i click a button that should update the subform to based on the parametres selected in the combo boxes. I realise i can't create a...

hi all, i'm trying to format excel from access (vba) and am having some trouble getting the last column used in my sheet. i have this: ilastCol = xlSht.Cells(1, Columns.Count).End(xlToLeft).Column ...which gives me the last used column as a number but i can't use the number in a range. i.e...

Hi all, i have 2 listboxes both have 3 columns. i want to pass selected list1 values to list2. the problem i'm having is that when i click the button to pass the values over they get added as rows instead of columns. so, if i selected row one from list1 which has 3 cols i would expect the 3...

thank you, i went for the recordset option. it works a treat. :)

thanks for the reply. there is going to be multiple users at the same time so the max option is not really going to work. I thought in SQL there was a SCOPE_IDENTITY(), is there an access equivalent?? can you point me in the direction of how to make an update with a recordset and then find...

Hi all, i am running some sql code that inserts records into my table from a form. I first create a record which is the header, i then want to add some records to the lines table using the unique id created in the header. I'm sure it must be possible, can anyone help/provide an example...

Hi All, I'm trying to print the contents of a list box (which changes dynamically based on the value selected ni a combo box so i cant use a query??? Can i ??), using a cutton on a form. how do i go about setting this up?? do i need to put it into a form first?? thanks. :)

would it help if i posted the code??..... Dim cnn As New ADODB.Connection 'This is an SQL Server connection Dim cmd As New ADODB.Command Dim prm1, prm2 As ADODB.Parameter Dim prmOut As ADODB.Parameter cnn.CommandTimeout = 200 cnn.Open connString cmd.CommandText = "[MyDataBase].MyStoredProc"...

Hi, I have recently (just about) got my head around using the Command colection. However, when i run the execute the first time everything is fine... i.e. Dim cmd As New ADODB.Command ...then i append all the parameters.... then.. cmd.Execute. First time round is fine but the second time...

Excellent, that works fine. Many Thanks.