Search results

At last, our prayers have been answered: Office 12 (Office 2006?) features a fantastic setting : "Alternate rowcolor". This would solve your problem if you can wait another year! ;)

Suddenly she saw

As she opened

Declare the variable at the top of your VB-project instead of inside a sub or function. Example: Option Compare Database Option Explicit Dim data As Integer Public Sub Form_Open(Cancel As Integer) DoCmd.openform "base" data = Forms![base].Form![name] DoCmd.Close End Sub Public Sub...

and wondered what

so she took

Suddenly her car

she needed to

A subform can be created by using a wizard, so I don't think we need to elaborate on that. A DLookup works like this: Me.TextBox.Value = DLookup("[FieldnameYouWantToDisplay]", "[NameOfYourQuery]", "[CONDITION]") The [CONDITION] part is optional. If your query only returns one record, you...

Ah! There you have it. :)

Isn't there a way to actually place the images in a directory somewhere on you HD so that access only displays the image instead of storing it in your database?

Hey Pat, Nice advice about the date/time values in one column. I gotta remember that. And about the DateValue, does TimeValue also do the trick then to get the time out of the value? Seth

If IsNull(Me.ComboName.Value) then 'It is empty... Else 'It's not empty... End If Seth

:eek: That was more difficult then I thought! ;) I attached your database to this post, I modified all the combo's to work. So, how did I do it? First off: For this to work, the name of your Control needs to be different from the name in your table. So to some control-names I added a "_"...

I'm working on it. Close to sollution, hang on for 10 minutes! ;)

I too notice that low esteem of access in my collegues, but when they need a quick and good sollution, guess who they come to... ;) Keep freshening up those skills, madrav72! One day we will be recognized for the geniusses we are. :D :rolleyes:

Sure. Don't add a recordsource to your form. Create a "ADD-query" (or is it an APPEND-query?) that will add all the values entered on the form to the table. Execute this query when the user presses the save-button (customized save button off course...). Seth

Haha :) Well good luck then, I hope you get the promotion! :) Seth

In the query editor you add Jan as a field, set it to sum and before the fieldname "Jan" you add "NameYouWannaGiveIt: ". So for example: January: Jan Seth

I had this problem also at work. In a multi-user environment, where your users have to work in the database (front end/back end), it's a guarantee for corruption and problems... We solved this by transferring our data to MS-SQL server. Since then, corruption didn't occur again. Maybe this...