Search results

Hi everyone, I have a blank. Its been a while that I have played with queries. I created a simple query that would filter out from 2 different fields on a form. The only thing is that I can use either one or the other field. If I use both, the query doesnt work porperly. ... see code SELECT...

I tried to split the database and got the error, "Subcript out of Range". Anyone got this and how can I fix it? Thanks in advance, Luc

Just a general question, I have created an Access 2007 database. There's about 10 users using it. The more they use it, the bigger the database becomes. At first I thought it was normal.... but, I tried a "Save AS" and saved it under another name. At that point the database was 20 mbs...

Crap, didnt work. Is there a way to simulate F5 on a field?

I do see the "flicker", like a refresh, but the new info is not updating!! Is there a way I can focus on the field name , then refresh??

I tried it and didnt work I do see the requery being done... but it doesnt check for new info. If I click on the field itself, and then click F5 on the keyboard, it refreshs fine. Is there a way to make it automatic?

I tried requery and refresh and it didnt work I might doing it wrong.... I tried: Me.Requery.txtmemo TimerInterval = 3000

I guys (and gals), I have a field on a form that brings up information from another database. The data is sometimes modified and I would need it to refresh every 30 seconds to check for new info. Is this possible? Thanks in advance, Luc

if 1 to 7 are for specific days, is there a value for all days?

Sweet, thank you very much! Luc

Hi everyone, I have a call tracking database. I'm looking to write a query that would give me the total calls on a specific day. What I have right now is a query that calculates total calls between dates per month. What I want to enhance to this query is to be able to specify a specific day...

Holy crap!! That's actually pretty good. I'll have fun trying to make this work. And I thought it would be easy!!! :eek: Well, thank you for the info. Luc

oh no no!! I probably didnt explain myself correctly!!! I dont want the field in Access to blink or change color... I want the HTM file to open... (see screenshot floorplan at the top)... and desk of the user to blink or change color once it comes up. This what I have till now... when...

Ok, thats sound good.... could I ask you to be a little bit more precise on how I could do this.... thank you, Luc

Hi everybody, I have a database of all the users (about 500) at our company. I have made a link that opens a HTML file with the floor plan when clicking on the user's location. Thats good.... but, what I would like is to make the location blink. Easier to find. I have divided the floor...

I dont know if this is what you are looking for user SETVALUE macro and set the [fieldname] = Now() ie: Item : [fieldname1] Expression : Now() Item : [fieldname2] Expression : Now()+1 Item : [fieldname3] Expression : Now()+2 PS - instead of Now() you can also use Date()...... Now adds...

Is this what you where looking for? I gave you an example from your Source Data Table. By searching with the query, you can search for example the vendor 3 just by entering part of it .... ex: 3... will find vendor 3 (under the field vendor) All fields are searchable, Hope it helps Luc

2 choices: A)Macro 1. Goto the properties of your 1st combo box 2. Click Event 3. click the ... on the right of After update 4. Select Macro Builder 5. Action = requery and Arguments = your field name (you will need to enter field name at the bottom where it says Control Name) that's it for...

Yeah!!! Got it to work!!! I dont know if it is because I'm using Access 2007, but the syntax was a bit different. I used : txtgroup = Nz(DLookup("group", "main code", "code = Forms![call details]!cboProblemType"), "Unknown") Instead of: Me.txtgroup = Nz(DLookup([Group],"Main...

AH ok ok... makes more sence!! but, I'm getting an error again.... might just be a little something.... Again, not too familliar with DLookup.... I've tried to fix it with no success. Me.txtgroup = Nz(DLookup([Group], "Main Code", "[code]='" & cboProblemType & "'"), "Unknown") error: I...