Search results

Ah yes. Exactly. What is ctl? Is it a recordset?

Listboxes. If I select some values from a list box, I would like to be able to use them in Visual Basic. It seems it is a little more complicated than declaring variables form a textbox. Does any one know how to work with Listbox values in VB? I would like to get the values and execute an...

No sorry. Just doesn't seem to work. I've checked the spellings. The table that I'm querying doesn't have to be open does it?

Hello Quick question: Say I have two different dataset types. Type A cam be stored in two tables, a main data table (call it Main_Data) and a metadata (Call it Metadata) table which contains information on Main_Data. There would be a one to many relationship between the relevant parent...

It seems to go in OK, but I get "#NAME?" in the Text Box

Hi everyone. Expressions in Access have given me some trouble before. Mainly due to inexperience. I hardly ever work with them. What I am trying to do is make the default value of a form textbox control the minimum value of a field A in a table A.The datatype of Field A is Date. So far I've...

Thanks for the advice ButtonMoon. I appreciate it!

Like: Table A Field1 has a one to many relationship with Table B field6 Table A Field1 also has a one to many relationship with Table C field10

This might seem like a stupid question, but is the general rule for a relationships between fields (one to many specifically) only one relationship per pair of fields? Will it cause problems if you have a field linked to two fields each through a one to many relationship? Thanks!

Proves the only difference between freedom fighter and terrorist is whether you win or lose respectively. He's no hero to me.

No one has used this method before?

I'm trying to use the WriteAllText method to write a text file based on some values in my database. ' Declaring Header Dim Header As String Header = "Line 1" & _ "Line 2" & _ "Line 3" ' Writing Text to file My.Computer.FileSystem.WriteAllText("[Pathway]", Header, True) End Sub The debugger...

Fixed the problem. I went for a different kind of append query, one that used VALUES rather than FROM (which is what I was basing it off) . I was able to use it in the same way as I wanted by just declaring some more variables out of the Recordset. Thanks for the help! ;)

Got it. Thanks. That's solved the error. but now I get a new one. Syntax error in INSERT INTO statement But it's got nothing to do with what you pointed out in: As I already had those declared before my first code example in the first post. I just didn't include them because it wasn't part...

I have it as a variable name: Dim Recordset Recordset = CurrentDb.OpenRecordset(Query) But I'll call it something else. I've looked at it again and I've got: Dim AppendCommand AppendCommand = "INSERT INTO Observations (Species_ID, Date_Of_Sighting, Longitude, Latitude, Number_Sighted...

OK, so I figured it out using a DAO. A Recordset in this case and a loop. Do Until Recordset.EOF Dim [Recordset_Value1]... 'Create Destination Database Pathway for each record Dim Pathway If [Recordset_Value1] = "1" Then Pathway = "[Pathway_1]" ElseIf [Recordset_Value1]...

Hello everyone, I have an append query that I would like to use to distribute records to a variety of databases. Some records will go to one, others to a second and so on. I have an idea as to how this would work in Visual Basic, but how can I make an append query work through a table on a...

These are in the property sheet?

A have a query that selects a multivalue field. The query forms the record source for a subform. The text values in the multivalue field are displayed in the query, but when I save this and view the data in the subform datasheet view the values revert to the primary key values. They are 1,2,3,4...

Bumping for replies. Are there any ideas?