Search results

Thanks Kiwiman, this works like a champ. I appreciate all your help! -Emery

Thanks Kiwiman. Well, it still goes back to the first record after I hit the preview button. Any other ideas? thanks for all your help so far. -Emery

Thanks Kiwiman. That does keep it on the current record, but breaks something else. So it looks like that is a necessary piece of code. So, is there maybe an additional piece of code that I can add after "Me.FilterOn = False" executes, that will bring me back to the previous record I was on...

Hi. I have an button that opens a report when clicked. Here is the code associated with the button: Private Sub Preview_Med_Expense_rpt_Click() DoCmd.OpenReport "rptMedExpense", acPreview, , IIf(Me.FilterOn = True, Me.Filter, "") Me.FilterOn = False End Sub It works fine, but I need it to do...

No, but I created all new buttons and used the code below, and it fixed it. Not sure why I had the problem to begin with. Also, I noticed there is a record lock setting on each subform's properties, so I set those to edited. So now the delete is working properly, and hopefully the multiple...

Hi. I have a shared Access 03 database, and the Default Record Locking is set to "Edited Record." Also, the options are set to warn when a record is being deleted. However, When 2 people have the same record open, they can both make edits. I never see the circle with the slash you're supposed...

Hi guys. I have this code for a button, that lets me filter records by selection, then preview a report on the filtered records: Private Sub Preview_Rpt1_Click() DoCmd.OpenReport "rpt1", acPreview, , IIf(Me.FilterOn = True, Me.Filter, "") End Sub It works fine, but I need to do it again for a...

Hi guys. This works, but I need to do this: 1. The full, editable database is copied to the host computer 2. Access 07 runtime is installed on the host computer, and all other networked computers 3. I can edit the structure of the database remotely from my computer that is on the network (I am...

Thanks Mike. That makes sense. Now all I have to do is figure out how to implement it properly ;) I'll start hacking away in the direction you suggest. thanks again. -Emery

Thanks Mike, let me digest your suggestions. BTW, where do you enter the Nz functions? Is in the Data tab of the property sheet, and then you put it into the Expression builder? thanks, -Emery

Yes, it's 20 values for each client. So in Filemaker, I would create one field, and assign it a property (20 repeating lines). In Access, do I have to create 20 actual columns--that is, add 20 new fields to my table--then manually line them up in the layout view of my form, and then create an...

Thanks George. I'm using Access because my office doesn't have Filemaker, and this is something I would have created in Filemaker. Access is the most similar Office product, as far as I can tell, so that's what I must use. What I am creating is a database of clients, and for each client we have...

Hi. I need to create a field that will allow me to input a list of numbers, and then another field that will calculate the total. I'll explain how I used to do this in Filemaker Pro: 1. Create a number field, set it to repeat (say 20) times. This allows you to input up to 20 different numbers...

Cool, thanks.

Hi. Is there a way to set the default view in Access 03 and 07, so when a user opens the file, the correct view is already open? For example, I have a simple contacts db. Inside are two views: a table view, and an individual client view. I want the individual client view to be up by default...