Search results

Hi, I have a query which selects a group of people relevent to a department, and since the group is more of a, list of certain people, rather than defined by titles (i.e. the group is the manager, the accountant, the clerk), my query just manually uses the ID's of the people required. (WHERE...

Put the objects you want fixed in the Form Header, and the rest of the information in the Detail section of the form. When you scroll the Detail, the Form Header will remain fixed..

what is the sql you are using? Is this a coded sql update or done using the query builder? I just did a test with the following that worked.. UPDATE Table1 SET Table1.name = testCase(1); Public Function testCase(bob As Integer) As String Select Case bob Case 1...

People have responded to your question, and have said to get a professional in to do it for you.. The simple fact that you're trying to use Access to handle such a large volume of data is a joke.. And furthermore, why is a Finance Manager (no offence to you) trying to build a database for...

Yeah, the OP didn't though :)

DoCmd.OutputTo acOutputQuery, "my query", acFormatXLS, "C:\querysave.xls", 1 that saves it to your c drive.. but opens it in excell for you, so you don't have to do anything with the file..

In your sickness table, are you using an ID that identifies each individual sickness record.. such as SicknessID or something similar? Thats what you should be using to delete a specific record.. Can you test the before update event with a message box.. just to make sure its working.. You...

nope.. You use the WHERE clause to specify which record.. I'm assuming you have a table that contains all the sick records. Each record should have its own unique ID value. This value should be in your subform, probably as a hidden text box. Then reference that in the WHERE clause... So...

the delete command is this DoCmd.RunSQL("DELETE * FROM TableName WHERE TableName.ID = " & Me.IDField) TableName is the table that your sick information is held.. ID is the PK for the above table.

Lol ok, it seems it was my crappy browser at work that was at fault (IE6) Do you have the group types stored somewhere?

I can't see anything between the lines "consider the following form and table set " and "also theres a query which contains the following fields"

in the before update event for the subform have some code that checks the isnull property for the fields.. IsNull(me.textbox1) And isnull(me.textbox2) then if this is true, run a sql delete command

Can you fix the post up please?

I can't test this on my work machine, but I would try installing an upside down font, and then formatting the text field to that font type.. Google upside down fonts

This is how i'd do it.. Ditch your junction table, and instead include a ResearchID field in you Tag table. In your form, have a subform that has the Tag table as its source, and is linked by the ResearchID to the master form.. This form will then show the Research item, and in the subform...

You could link to the excel file so that access treats it like a table.. That way whenever the excel file is modified the database is also..

I'm not sure about others, but I can't open that file you attatched..

:O I wish i'd been using this from the start.. This tool is brilliant..

Sounds like I might need to take a look at MZ-Tools.. Do modifications made using it work on a computer that doesn't have it installed.. meaning if I use it, then distribute .mde versions of my db, do the users need anything extra installed?

Antoher way is to use generic error handling code.. But have a variable at the top of each sub/function that contains the procedure name. Private Sub Command0_Click() On Error GoTo Err_Command0_Click subName = Command0_Click then in your error code just reference subName