Search results

Go to the cboClientFacility Properties, Data tab, click on the Row Source and then the ellipsis (...) on the right. This will put you in the query designer. You can close the Show Table dialog, switch to SQL view and copy and paste the SQL in. Click Yes to save when you close the query...

First there's some strange expression in the on change event of the cboClient combo. I suggest just deleting it. Let us know what you were trying to do and we'll figure something out. The cboClientFacilitycombo needs a row source that depends on the selection in the cboClient combo. I...

I don't think anyone gets angry about this. We just don't want to waste our time if someone on another forum has already taken care of the problem.

Normally the bound column of the combo box for the Client would have the primary key of the client table. The row source query of the facilities combo box would also have this as a foreign key. In the criteria of this field you would put a reference to the client combo box. Something like...

What's the problem or question?

I've attached a database with a solution that works with limitations. To see it work open the form frm_link_outs and click on a sample name. You will see the URL in a message box. I have the FollowLink commented out as it of course just causes an error on my system. If you want to test the...

Haven't heard anything from you for awhile. Did you look at the latest version I uploaded?

I was just working on that. I was going to loop through the field names of the crosstab query (sample names) and try assigning them to a form with generic controls names like T1, T2, T3. If you can live with a form with a fixed number of controls that would really simplify this task. Can...

Getting to the crosstab query part is fairly easy. In the attached database I added what's called a cross product query which is just the tables with no join. This produces the permutation of the records of both tables which is what you want. I added an expression which is entirely bogus but...

Yes the db example would help. And if the end goal is for the form to present hyperlinks I would like to know the form of the address so that I make sure my suggestion will support it. I don't need it to be exact. Something like: https://someaddress?sample=32&gene=94 and where the data in...

I'm sure it's possible but before I suggest something I'd just like to confirm that all you want is a grid with the GeneNames and SampleName; no values like Start or end. Is that right? Also if the result is not editable will that be a problem?

You can look up the ASCII codes on line like here for example but it's just easier to use Debug.Print as in the following code to find out what they are. If you press Escape and Return you will see in the Immediate window that they have codes 27 and 13. For the KeyPress event to fire Key...

Of course it was really your code. Anyway I figured out the late binding problem. I was reading about late binding and it said When I saw CallByName I thought why not give that a try which led me to this page where I saw that the folder has a type of Variant. That was the problem. If you...

I don't believe any of the methods we came up with work on a linked table. If the table is in the backend you would need something like: Sub tsql() Dim sql As String Dim db As DAO.Database Set db = OpenDatabase(GetBackendPath) sql = "ALTER TABLE NameOfTable Alter Column NameOfField text(25);"...

Also CurrentDb.Execute "alter table NameOftable alter column NameOfField Text(25)" Changes the field with to 25.

When I search for Shell32.dll on my system (Windows 7) I get more than 30 hits. Assuming the OP has lots of them too what's the chances of the right one being selected for a reference. I think we need to find out why this reference isn't showing up in the OP's references at least if it should...

@jdraw, Since this works on both of our systems this appears to be a problem with jray9242's environment which appears to be Access 2010. What version of Access and operating system do you have? @jray9242, Same question. What version of Access and operating system do you have?

I don't understand what you are saying or asking here. The additional note is typed into the unbound textbox by the user. When the button is clicked that information is tacked on to the end of the existing note and stored there. Of course you could bind the additional note textbox to a table...

It looks like you can just lock the existing text box on the form and then concatenate to it from another unbound text box with code like: Me.JobUpdateNotes = Me.JobUpdateNotes & Me.NewNotes Me.NewNotes = Null You can see this in the attached test database.

If you can run the query that has the form reference from the form without problems you should be able to assign the query as the record source of the report (Report Properties, Data tab, Record Source) and run the report from the form but at this point I'm confused about your confusion so I...