Search results

Sorry DCrake, It's the first time that I play with DLookup and havent gotten the logic behind it. I'm reading about it has we speak... One question though, What are you refering to when you used "Unknown"?

Here's the code I tried, and doesnt work.... any ideas?? Dim strSQL As String strSQL = "select [MAIN CODE].[Group]FROM [MAIN CODE]WHERE ((([MAIN CODE].[Code]) " = [cboProblemType] Me.txtgroup = DLookup("group", strSQL) here's the error :

Thank you for all your help.. I'm trying to do what you gave me (boblarson) but I'm getting the error that it cant find the field name.... make sure it exist and try again..... I know it exist because, it gets populated by the first combo box. I might be missing a little something and not...

I tried this, but it keeps kicking me back to my first entry...( or ID) it's weird!!

Question - The list in the combo2 has about 50 different entries.... Are you saying that I would need to write a code saying.... if combo2 = "whatever" then combo3 = "this and that" 50 times???

I have a combo box (lets call it combo3) that is filtered by 2 other combo box (combo1 and combo2). Once it is filtered by combo1 and 2, I only have one entry in the combo3. Is it possible to auto select that enrty so that the user dont have to click and select that combo box 3? Hope I'm...

cool, thank you!!! That actually worked great!!

Access 2007 I have a query that checks for New Accounts: SELECT Customers.ID, Customers.[Last Name], Customers.[First Name], Customers.[New User] FROM Customers WHERE (((Customers.[New User])=True)); What I would like is a flag created on a form to let me know that there's a new account...

or you can try this : In your query add this to the Criteria of your date : Between [start date] And [end date] or add this if you have date fields that are blank IS NOT NULL AND Between [start date] And [end date] You'll be ask to enter a start date and an end date (ie: 2008/01/01)...

I changed it a little bit. I went to the button that I created, and under the onclick event, I selected code builder and entered this : Dim PassWord As String PassWord = InputBox("Enter Password") If PassWord = "enter your password here" Then ' Open Form DoCmd.OpenForm "the...

That's good thank you.

Hi everyone, Thank you for everyone that helped me before, I'm getting better eveyday because of you. :cool: I would like to protect a form with a password. Can anyone point me how I could do this. I do have a password when accessing the database. But, I would also like one for a Form...

I should have known this. Sorry for that!! Lucas

crap... I'm not getting the right data... I thought it worked..... Would you have this in SQL verison---- Create a query that lists the DateDiff() between the start and end values in minutes Quote: TotMinsDateDiff("m",Start,End) Then create a new field in your query called Quote...

AH ok... got it.... oups... thank you very much :o

... no luck!! take a look I might not be doing this the right way!! :rolleyes:

reply Thank you DCrake for your quick answer, I'm just running into a problem when I add : Duration:MinsToTime(TotMins) I'm getting the error when running the query: Undefined function 'MinToTime' in expression. Yes, the module has been created and I do see it under modules. Any...

I have a call tracker database. What I'm trying to create a query to view all my calls' time average (opened date and resolved date). Basically, how long it took to fix a call or problem... whatever... I tried with datediff(), but had problems getting the Total Avg. I would need the query to...

Thank you gemma-the-husky and raskew. That helped a lot. With the SELECT format, is there a way to select a specific day (from and to a certain date)? I'm assuming that it can be done with the code, but , I'm looking to select a date from a text field on a form. Which would change the query.

I use a database that tracks calls answered during the day. I have a fielded called "opened date". What I want to do is to show what part of the day is most busy. Ex: between 8am to 9am (how many calls where answered) between 9am to 10am (how many calls where answered) and so on.... I...