Search results for query: *

The button has the following event: On Click = ProcessTextFile(arg1) The function ProcessTextFile() is passed a single argument when it's called. I want to pass whatever the contents of a particular text box are (let's call it TextBox1).

Hi, I have a form in Microsoft Access. There is a textbox which contains a filename, and a button which calls a VB function. i want to pass the string in the textbox to the VB function as an argument. How do I do this?

That returns both records.

Hi. I have an Access database of cards for a trading card game, some of which have identical names, although their other fields may not be identical. Example NAME - COST - CARD TEXT - YEAR PRINTED Fog - G - No creatures deal damage in combat this turn - 1995 Fog - G - Creatures deal no combat...

Cheers, that's working well! One more thing on a related note: If I apply a filter to the recordset in the form, how do I update the listbox so that it displays the filtered list?

I have a form which displays various fields from a record in a table. I've got those little arrow buttons at the bottom of my form so I can change the current form being displayed. But I don't know how to add an element to the form myself which I can use to select the current form. What I want...

Indeed. I notice that you CAN set the background color with a cell with this command in all 3 browsers: oCell.style.backgroundColor = 'rgb(255, 0, 0)' but if you test it's value you still get 3 different return values: IE returns 'rgb(255,0,0)' (no spaces) Opera returns '#ff0000' Firefox...

I'm running that code in Firefox 1.0PR and it's not working properly; cell colors rotate as far as green, and then stop changing. It returns a value in the style 'rgb(255, 0, 0)' which will not test positively against '#ff000'

I'm writing a Jscript version of mastermind, code here: http://mysite.wanadoo-members.co.uk/shteevshouse/games/MindMaster.html I'm trying to fix it so that it works for Firefox as well as Opera and IE. Each cell can be one of six colors. When I click on a colored cell, I want it's color to...

Finally found it :) Set the following properties: Data Entry: yes Tab Key Cycle: Current Form You can then set 'Navigation Buttons' to 'No'; although having just discovered how to do all this I'd be wary of it in case I somehow managed to increment the record, and wouldn't be aware of it.

Thanks for your help; the purpose of this form, however, is to allow a user with no experience of Access to enter data, so I don't want the form to be able to display data for more than one record either, to avoid confusion. I've solved the problem now. I don't fully understand where I was...

I'm constructing a form in MS Access to allow the user to enter data into a table. However, I only want the user to be able to enter one record each time the window is opened. Is there an easy way to do this? What I've done is create a form which is not bound to any table; the user uses objects...

This works great! I had tried [null] which didn't work for reasons which appear all to obvious to me now...

Hi, I want to make a union query which adds 2 tables together; but I want it to contain a field which is in one table, but not the other. For entries in the second table, I want the union query to contain a NULL. So, something like this: SELECT [field1], [field2], [field3] FROM [table1] UNION...

Is there also a simple way of setting up the form so that only one new record can be added?

Ahh, lovely, I knew it couldn't be anything too complicated. Can anyone help with my second problem?

My other problem is how to GET data from elements in the form, so I can pass that data to other elements. Specifically: I have 2 subforms on my form, both showing entire tables, as a datasheet view (so the user can sort/filter the data shown). I wish to select one record from each of these...

I've hidden a form in MS Access, by right clicking on it in the main database window, selecting 'properties', and clicking the 'hidden' box. How do I unhide it again?

Ok, I think I understand, but there's a problem and I'm clueless how to solve it. I've simplified the code down to this: Private Sub Attach_Comment_Button_Click() Dim strSQL As String strSQL = "INSERT INTO CommentXREFQuestionnaire" & _ "VALUES(""28"", ""E"", ""2"");" DoCmd.RunSQL strSQL...

I was hoping to get away without using Visual Basic cos I'm not very skilled with it. But it doesn't look too hard to achieve. I don't fully understand the code you've written, tho; It's constructing an INSERT query on the fly, but whats with the _ and """ characters?