Search:

You may have to add a line of code after the DLookup function = 1
DoCmd.OpenForm "frmName" Or DLookup function =2
DoCmd.OpenForm "OtherfrmName"
I'm not sure, Maybe Scott can solve this.

Hi ans sorry about that code. It won't work. I don't know what I was thinking. I got mixed up with Visula basic.

Try this, I tested this and it works.

Private Sub cmdLogin_Click()
If...

Should be lblPromp.Caption
I couldn't find a edit answer button.
I noticed I made a typo. Sorry.
Rob

Hi,

I will assume you have the passwords and user names in the same table.

I believe the code may go something like this.

Private Sub cmd21_Click
If txtPassword.Text = "mypassword"...

Thanks again Scott. I won't be supporting it. It sounds bad, but it will be sold as is. I hope If I split it and test it, that will be the final test. I would have to use a Delete Query and reset...

I had a feeling about that Scott. I tested the database on Access 2000 and it could'nt read that line specifically that constant. Thanks Scott for letting me know. I appreciate your input as...

You can remove this question if you wish

Hi Scott. Nice to hear from you and thanks for replying. I haven't used the splitter thus far. I guess If people are not on a network and I split the database, I'm assuming I can tell prospects...

I used Access 2003 to create a database and saved as Access 2000 format. I used some code that downloads a logo. This won't work in Access 2000 because of the Library Microsoft Office 9 Object...

Hi, maybe you can put this in the control source for OpeningBalance.
=IIf([TransDate]>#03/31/2006,0,CLng([Deposits]-[Withdrawals])

You may have to tweak it for the form.

Rob

I sent you an email. The exercise looks simple, but requires you to enter Sept 1 balances and account numbers for the Balance sheet. The rest is making journal entries good luck rob

Hi,

I think you just want the ContactName. So the properties for the combobox should be like this:
Record Source SELECT ContactID, ContactName FROM tableName ORDER BY ContactName;

Bound...

Scott, I just came back from a showing, I had a death in the familly. Maybe 'I'm a little touchy. Refresher course, not a bad idea. Hey, he may be right. Take care, Rob appreciated your help.

Again, you are right. I just posted on MS. Feel free to read. Dare-Devil gave me some sound advice. Maybe not what I wanted to hear, but I don't know. Fell a bit hurt.

Scott's answer is correct. That is the work around if the record will not move due to no data entry on the main form. So Access doesn't know a new record wishes to be created. The one thing that...

Yes, I thought about that. It would have been nice to have that identifier with the date and sequence, The Save button can be risky. Each time user clicks on it, up goes the sequence. User must be...

Thanks Scott. Read my answer to the question. I posted there because of limited character space here,

Thanks Scott. It does work, and I figured out late last night it wouldn't update unless I had another field on the main form.

The save button could be somewhat confusing to a user, but does work....

I deleted the fields as mentioned. Now the only thing is I'm shaking my head because the GLTransaction is unique to the entire entry. So much for a GLID composed of a date and sequence number. I...

This worked Scott. I'm not sure if the user will understand the Save Button to be pressed before entering the detail. I knew that was a problem last night when I change the Sequence number in the...

The attached database has the tables and form and subform
The purpose, the answer I am trying to find is 1. why is the autonumber in the main form not incrementing? 2. I require a unique...