Recent content by workmad3

if you have a logon form in your db that you created yourself, and a list of users, then you can always have a 'logged on' flag next to your user that is set when the user signs in and is unset when the user exits the app or clicks a log off button. Not the most effective way, but it should get...

boblarson: I know that. I only indented the if statements where he had spanned the statement on to 2 lines :P

indentation helps you match things up, for example: Private Sub Form_Load() If frmOyezstrakerCustomerMailOrderSub!CustomerCardTyp e.Enabled = False Then Me.CustomerAddress.Enabled = False If frmOyezstrakerCustomerMailOrderSub!CustomerCardTyp e.Enabled = False Then Me.CustomerPostCode.Enabled...

Is that an exact copy of your code? if so, then look at the section here If TextEntry <= Right(Text121.Value, 5) And TextEntry <> "0" Then MsgBox TextEntry & ", " & Right(Text121.Value, 5) & "Not allowed" Text123.Value = "" Else: 'here is a label, not an else...

Standard message boxes are modal, meaning that the user can't click off them until they have done something with it. I can't see how much more attention grabbing you could be. A blinking form is more likely to annoy your users than anything else :) (I know it would annoy the hell out of me :P)

you can't use a delete query to delete just specific fields, which seems to be what you are trying to do. I would suggest "DELETE FROM tblHolliday WHERE ((tblHolliday.Date) Like '[forms]![frmtest].[txtday1]')"

Before doing anything, I would check your update statements too. At the moment they have no where clause so will change EVERY value in the table you are updating to the one you are setting..... just a quick warning :)

It is unlikely to be a CrLf character, as access sees this as a new line and prints it out as such in all of its controls and tables. There are plenty of other things it could be though :D If you work out what it is, please post up ;)

I don't think there are any real downsides to compact and repair. There are several downsides to not compacting and repairing, such as huge sizes for databases etc. If you are doing heavy modifications to data, forms or data structure you really need to compact on close (I had some files shoot...

Because access is what my boss wants me to work in :( I personally would have done exactly what I have done in C++, Java or C# a lot more happilly.... but the boss decided access is what would be used :( Oh, and my dislike of bound forms is that I find they restrict me too much. I like to be...

finally fixed the problem. Ended up needing to set the bound column to a non visible column and setting the frameID through that. Means I can't put in my message saying nothing is selected, but a blank line is just as obvious.... it will just have to do I guess :)

not an option at the moment.... mainly because I dislike bound forms and so the system is designed to not use them.

Ok, I have a form (unbound) that I have written my own load and save methods for. On one of the subforms (there are about 5) there is a combo box that is populated with a select query. I save the ID from the combo box into the database, but I am having trouble getting the combo box to then load...

I think you need format conditions, try googling them or searching on the forum to make sure :)

create a query UPDATE table SET Approval = "No" WHERE Coordinator IS NULL Or Coordinator LIKE '' UPDATE table SET Approval = "Yes" WHERE Coordinator IS NOT NULL And Coordinator NOT LIKE '' put that in as the SQL for 2 queries and run them. Changes you may need to make are: The "yes"/"No"...