Recent content by Super Suarez

Hi All, How do I make the windows default navigation work to the following:- Next record that navigates to next, but does not create a new record when at EOF New record that creates a new record. I've tried turning off 'Allow additions' for the form, but that turns off the 'New Record'...

If a row has been used it will have data in it. Quite what data I'm not sure, but it will not be empty. I've been trawling the net for an answer. All a bit confusing

Hi All, I have the following code which returns me the number of rows in an excel sheet:- Lastrows = .Worksheets(1).Cells.Find(What:="*", SearchDirection:=2, SearchOrder:=1).Row How do I mod the code to find the last 'used' row in the sheet? The sheet is automatically generated daily, so...

Well in the end it worked via the following:- [List num] = tempnum Which I thought was a bit strange. I have got my terminology right here for parents and child. The main form has a button which opens a further form (which I believe is the child) right? It is in this child form that I have...

It's not writing a value to my [List num] textbox on my main form. I've tried msgbox() instead of debug.print but again nothing except for msgbox("Tempnum " & tempnum) where it does output tempnum. it's rather bizarre

Thanks but no that's not working.

Hi I have a variable tempnum on a subform which I want to pass into a textbox on the main parent form. I cant seem to get it right. Here's my code Me.Parent.Parent![List num].Value = tempnum Hope you can help

I don't think I need a sort. Just advice as to whether an array in a cell is the best thing to do ie something comma delimited (9,4,7,2,1,4) or should I write each entry to a cell and create fields as the arrays get bigger. Or perhaps there's another way I've not thought of

Hi What's the best way of storing arrays of data within a cell? Or should I be creating fields to the size of the array. The size of the arrays are unknown at the moment, so I'm wondering the best way to go. Hope you can help

I'm not sure I follow. I have a sub form with a textbox, and if I say type 5 into that textbox, how do I get a further 5 textboxes/labels to appear?

Hi, I'm trying to get some labels and eventually text boxes to become visible on an input of a qty in a text box, but I can't get my syntax right. Hope someone can help. The labels are numbered pumplbl1, pumplbl2 etc Here's what I have so far. Private Sub More_qty_AfterUpdate() Dim count As...

Thanks for that. I can run some code on a new event too inside that function:- if me.NewRecord then .... end if Thank you again

Hi guys, I want to run some vb code when I use the next/back/new buttons on the defult windows navigation at the bottom of a form. How do I run that code? is there a Form_load() type function I can put it in?

Thanks for that. I'm not sure if I made myself clear. I want to be able to vb code events from the windows default navigation buttons along the bottom of the form. I understand they are there on my form and I can navigate, but I want to create events from those navigation buttons rather than...

Hi guys, how do I get access to the default navigation buttons on a form ie back, forward, new and last buttons. I want to right some VB code that acts when the buttons are pressed. How do I do it? I don't really want to create my own buttons and do onclick events Thanks