Search results for query: *

If I have two tables Table1 & Table2 with a one to many relation ships, create a form with Table1 and Table2 as subform. I now want to open this form from another form and select a record in the main form and a related record in the subform. Could someone be kind enough to show me how with VBA...

Can I use a vba function that I have written in a query, im getting undifined function if i try this.

Does anyone know, how you can search for a character in a string like the Find function in Excel. I have a field Full Name that is first name and surname together; I need to strip out the first letter of the surname to sort on.

I have a simple select query that has no criteria, therefore shows all records, I want to use the left function to strip out the first letter of a field called “Full Name” which is the primary key of the table, however if I write Prefix: Left([Full Name],1) I get this error “The specified field...

I have set the properties of a form for datasheet only by default view and view alowed, however, when i open the form from the database window it goes into datasheet view, when i open the form from a command button created by wizard using docmd.openform it goes back to form view. Any ideas?

I have re-written my problem that’s already posted just trying to make it a bit clearer. I have a main form – sub form, were usually in the sub form, on the new record line, the foreign key field usually is filled in with the primary key, what im getting in access 2000 is the forms name not the...

I have a table names Staff Members with fields, Name, Job and Area. I have a second table names Courses Attended with fields Name, Course and Date. I have a relation ship between Name and Name in the to tables, ref-integrity turned on and one to many shows ok in relationships. My question is...

Would anyone be kind enough to let me know how I can assign a url to a button, or let me know the VBA code, so that when a user clicks on a button on a spreadsheet it opens a url in the default browser. Just like as if you insert a hyperlink in a cell with the insert hyperlink button. Thanks in...

Hi this may sound a bit of a mad request but I need to crash my PC. I writing ECDL manuals and need to get a screen shot of task manager with a non-responding application. Anyone know a way of hanging a office app or could think of some VBA code that won’t cause the debugger to switch in and...

Ok I have 2 related tables, Table1 & Table2, Table1 is related to Table2 by ID fields. I make a form on table1 & a form on Table2. I then put a button with the wizard on the Table1-form that opens related data in the Table2-form. This works fine when there is related data in Table2. However when...