Search results

I am using Access 2007 to create a DB for Access 2000. I knew about the zero based thing, but really "nothing" happens when I do this. Yes, other VBA code works fine. mvorous

I tried the following code to "select" the 87th record out of 100 & nothing happened. Any advice? Private Sub CmdBtn_Click() Me.Patientlist.Selected(87) = True End Sub Thank you, mvorous

Hello, I have a form with a simple list box of records. I would like to click a button and have a particular record selected -"highlighted" as if actually clicked upon by user. Can this be done? Thank you, mvorous

What a rude lady you are. Please don't respond to any of my requests for assistance. I'd rather do without. mvorous

Hey, I remembered an old method, probably not too sophisticated but... it works. Private Sub ApplyCount_Click() Dim myAdder Dim mycounter DoCmd.GoToRecord , , acFirst myRecordIndex = 1 mycounter = Me.RecordsetClone.RecordCount Do While myRecordIndex < mycounter + 1...

I don't want the auto #. I have users assign large profiles to specific people, rather than use the peoples names, I have it set up for the assigner to simple pick a number. Person 1 would equal record 1, etc. It is very fast this way. I do it in VB but here in Access, it is becoming a...

This may help, in a form at the bottom, if "navigation buttons" are allowed, you have "Record, 1 of 50 & 2 of 50. I need to tap into that. Jeez, I know VB allows this but does Access? I sure appreciate the help, mvorous.

I do want the record to be reused. If it is deleted "which is done every 6 hrs" then I still want the count to be sequential. I can't seem to find to much on recordcount, if I may, an example please. And thanks to all. mvorous

Thanks WayneRyan, I botch'd my question so badly that I started over. mvorous

Mark, hi, I'm no expert, but I think your problem is that your checkbox is "unbound". It needs to retain its value, saying that, it needs to exist in your table. Hope that that is it. mvorous

Hello, I have a form that has its default view set to continuous form. I would like to have a textbox store the record number with each new record that is created by the user. The first record of course, would be "1", the second would be "2", etc. What property of the recordset stores this...

Thanks Wayne, that works fine, but what I mean to say is... Say I have 50 types of plants in my dropdown list, available for users to pick, I don't need to know that they picked the 4th item in the plant list, I need to know with each plant they select, a returned value, 1 for the first plant...

Hello, when a user selects from a combobox, say the fourth item in the list, I need to have that "4" value returned to a textbox. Simple, I hope, thank you in advance. mvorous:confused:

See post (answering my own question...ha!) http://support.microsoft.com/kb/233274

G'day Can anyone direct me to code that shows drag -n- drop functionality for the users? I would like to have the user drag a name from listboxName & drop it into listboxSelected. Thank you, mvorous

wiklendt, thks for the post. I will keep looking for solutions... mvorous

Hello, two simple issues about fonts. I have set what I could find in Access Options to address these issues, but still it persists. 1. When I insert a simple button I initially get font "Calibri". I want it to always be the same as the rest, such as "Tahoma". 2. In the VBA code editor...

Problem solved, thank you all very much, exp. pbaldy & RuralGuy(http://www.btabdevelopment.com/main/QuickTutorials/A2K7Howtoenablecodeandmacros/tabid/57/Default.aspx). It was a non-trusted issue. Thx all...

Yes, that was it. A non-secure or rather non-trusted issue, thank you very much.

I just quickly created a new DB with a few new fields in a new table, the code worked as it should. Here is the difference in the other situation, The Tables are all imported as I need it to be a Front-end/Back-end relationship. Does this help? Thx