Search results

Lets start with the controls on your main form. What are their names, types and which are required e.g. mytext1 > textbox > required mycombo1 > combobox > required mytext2 > textbox > not required etc First i'll show you how i check for required fields Are you sure you want to...

Why not test your Nulls theory out by replacing Nulls with some dummy text

I'd first check that the textbox values you are using in your query are as expected. Comment out your Query and insert the following: Dim myvar1, myvar2, myvar3, myvar4 As String myvar1 = [Forms]![TimeSheet Search]![Week Ending] myvar2 = [Forms]![TimeSheet Search]![Employee Name] myvar3 =...

Hi, In your intial post you said you had a form then in your last one you mentioned a subform too. Could you give some more detail? If you just want to append a record to one or more tables but first make sure that a bunch of fields have been filled out, you only need one button to do that.

Hi vbaInet, Thanks for your reply. I did try your suggestion but what i forgot to say was that one of the fields in the datasheet is a hyperlink and so i couldn't set it enabled=no (if i did then the hyperlink wouldn't work) Since this field has enabled=yes, it would assume focus. Sorry for not...

I never did get a satisfactory answer to this question. The conclusion i reached is that only controls that are useable in the datasheet e.g. textboxes can be set visible and can therefore receive focus. Furthermore, the focus must be set to at least one of these useable controls (the one...

Hi GalaxiomAtHome and everyone else who helped point me in the right direction. Thanks for preventing me travelling down a road of pain. I tried your suggestion and created a junction table between the Process Step and Type tables and everything fell into place beautifully. I can't believe how...

Thanks to everyone for your replies. From reading this and other forums, I got the impression that what i was trying to do was not such a good idea. The problem i have is that i need to be able to add new product types and select which process steps are associated with each type (so you have...

I'm still not sure why it worked in design but not in run mode but i fixed the problem by deleting the parentheses from the following line i.e. changed CurrentDb.Execute ("ALTER TABLE tbl_mytable ADD COLUMN abcd;") to CurrentDb.Execute "ALTER TABLE tbl_mytable ADD COLUMN abcd;"

Dear All, I hope someone can help explain why i can achieve the following at design time but not at runtime. I enter text into a textbox txtEntry on a form frm_MainForm e.g. enter abcd then click a command button to execute some code with the following effect: A new column "abcd" is...

Hi Linq, That worked but then the subform scrollbars lock up. Nice one Microsoft for making what should be easy nigh on impossible.

Yes, as i won't be editing any info presented in that datasheet. The first field that is highlighted is a hyperlink and the other fields are just straight text and number fields.

Hi Linq, Sorry for the delayed reply but i seem to have missed your reply. The cursor moves to the left of whatever's in the field with the lowest Tab Index and isn't highlighted. It looks better but you still have a blinking cursor. I just want the subform to appear as a datasheet, no cursor...

Hi Linq, Thanks for your reply. I tried the selLength suggestion but all it does is put the cursor to the far left of the text box (as opposed to the whole of the text field being highlighted) Is Access really so clunky that you can't easily choose not to have a field highlighted on a...

I have a subform datasheet that defaults to the first TabIndex field so the text is highlighted. Is there a way to remove focus from all my subform controls (they are all text/label pairs) or some trick workaround similar to setting focus to a transparent button (which isn't an option on a form...

Hi Everyone, I have 2 tables: tbl_lot lot_id (PK) lot process_step_id 1 lot-a-01 1 2 lot-a-02 2 3 lot-b-01 1 4 lot-b-02 1 tbl_process_step process_step_id (PK)...

sorry, and you also need to change the following button events On Mouse Down =SelRecord(frm_subform.Form,"Down") On Mouse Up =SelRecord(frm_subform.Form,"Up") On Mouse Move =SelRecord(frm_subform.Form,"Move")

Thanks Bob, Success! The previous code works when I change Set F = Forms![Form1] to Set F = Forms![Form1]![frm_subform].Form where frm_subform is the subform / report name Thanks again, Mark

Hi Bob, Thanks for your reply. I thought i'd start by posting the code for the part i've got working - that is, the ability to enumerate selected records in a Continuous Form and update a certain field (my_field2 in this case) with a certain value ("999" in this case) It might be...

I wondered if anyone could help as i've been at this for 2 days now: The following article 294202 which can be found by Googling "MS ACCESS ENUMERATE RECORDS" (sorry but i don't have enough posts to give the link directly) describes how to enumerate records in a form (which i've managed to...