Search results

I'm assuming the type mismatch error is coming from your SQL statement. If that's the case, Debug.Print your strSQL in your immediate window and see how it looks like first.

Yes as Isskint mentioned, you're looking at WindowWidth rather than width. Something like this:

A good reference to how dlookup works: http://msdn.microsoft.com/en-us/library/office/aa172176(v=office.11).aspx Using count(*) in dlookup returns the number of records

Lets say your subform contains the orders of your Clients. I would put the below in the form's Current event. If dlookup("count(*)","Orders","ClientID = " & me.ClientID) = 0 then me.OrdersSubform.visible = false else me.OrdersSubform.visible = true End if

Welcome aboard Tinuviel, Why not use VBA instead? It hasn't changed much since Access '97 If you can share what the Marco did I can convert it to VBA for you.

In my 10 years of working with access I have never had the need to create tables in run-time. Can you explain why you're doing that? Also, access understands decimal places rather than significant figures. You can format your numbers to show in scientific format as in 5.32e-3 if you want.

Yeah, you can change the buttons left & top properties when your form is loaded. Something like this maybe: Let's say for some weird OCD related reason you wanted your button to be centered at 90% of the forms width, then your code should look something like this: Me.MyCloseButton.Left =...

Let me know how the self-smacking goes :)

What exactly are you trying to achieve here? Sounds like your data model isn't very solid.

Well, open this table in design view: tblEmployeeDetails And add all those fields that you want. Then go to the form's deisgn view and add whatever fields you want.

Aziz, you can't make references and quotes from the Holy Qura'an until you've established that it's a common credible source to everyone on here. In which case it isn't. Bottom line is, religion and logic will never go hand in hand, and as a Muslim, you're requested to obey and not question aka...

Welcome aboard!

Can you give us more background? How are the tables related? And what sort of end result are you looking for?

You can call the above code by writing the following: CheckPassword "YourFormNameHere"

Something like this?

Of course Put the below in a module Sub CheckPassword(formToOpen as string) If dlookup("count(*)","UserT","password= '" & CStr(textpw) & "'") = 0 then MsgBox "Sorry, Your Password is incorrect." Else DoCmd.Close acForm, "PasswordaddF", acNosave DoCmd.OpenForm formToOpen End If End Sub

Mid function => lets you choose part of a string Max function => get's the maximum value of a certain field in a table Dlookup function => Looks up values from a table So you're basically looking up the maximum of a part of [codes] from [table3] How can search MSDN for each of those functions...

So, what did you end up doing?

So as the title states, any F1 fans on here? I know it's large in the UK I searched and couldn't find a thread about it

A very wise scholar once said: "Religion is like a penis. It's fine to have one and it's fine to be proud of it, but please don't whip it out in public and start waving it around... and PLEASE don't try to shove it down my child's throat." :D