Search results

I'm trying to build a dynamic sql query using VBA, thing is, i don't know how to assign a certain sql script to a Query in the database from within VBA. Any help would be appriciated! Ted de Vries

I have a question. I want to able to search for a record in a form using VBA. I've constructed the following while loop: Sub SelectCurrentBeg(dBegid As Double) Dim temp As Double temp = Begid.Value While temp <> dBegid DoCmd.GoToRecord , , acNext temp = Begid.Value Wend End Sub Now the...

I have a question. I want to able to search for a record in a form using VBA. I've constructed the following while loop: Sub SelectCurrentBeg(dBegid As Double) Dim temp As Double temp = Begid.Value While temp <> dBegid DoCmd.GoToRecord , , acNext temp = Begid.Value Wend End...

Rowselect with Listbox?? I'm creating a system where a list of volunteers must be created. Three of these volunteers must be easily selectable with the press of a single button. I have created a listbox with all the volunteers in it. Now the thing is, you can't select a whole row of text in the...

Hi, I have a question, i can't seem to find a suitable control to use on a form i'm making for a project. First let me tell what the form is supposed to do. At the right side of the screen there's supposed to appear a list with volunteers sorted by grade ( which are calculated in the system )...

Newbie question :) I have a very simple question. I'm working on a school project now, but i don't have too much experience in access. The thing is, i have a Table A and a Table B. Now when i insert a record into table a, at the same time a record must be inserted into Table B with the same...

I have a question for school. We are doing a project for a company, whe're rebuilding they're current database. What my problem is at the moment, is that i have one form which i have a query attached to as datasouce. The selecting of the records works just fine, but now i want to add new...