Search results

Ok so I cheated a bit but achieved similar goal... Basically after the loop has been run, I run an sql query that updates my records to a 1. Not the classiest method, but it works. DoCmd.SetWarnings False Dim db As DAO.Database Dim rst As DAO.Recordset Dim qdf As DAO.QueryDef Set db =...

Well I'm not using the code you linked to, since I'm using a different method I get errors. Anything other ideas?

Ok so I managed to find some code that worked (see below). The problem I have now is that I need to set a flag in my table that indicates an email has been sent already. To do that I have a field called "ReminderSent" which is either null or 1 and my query selects records which are not null...

Thanks for the quick response. I did see that code while searching for an answer but I must admit I have no idea how to implement it in my DB because I don't fully understand what the code does and there's no explanation with it.

Hi guys, I'm building a database that manages licenses for a software that we sell. I have a small problem and I can't find the proper keywords to finds a solution in the forums. Here's what I have: A table with demographic info as well as a 2 date fiels (Date_Activ and Date_Renew)...

Ok, I think I understand. I'll get back to you if I have further problems! THANK YOU!

Hi guys, I have a problem which might be eay to fix but I can't figure out how to do it. I've searched google and the forums but can't find the exact wording. I have a main table which holds different companies and their demographic information. Periodically, these companies will send me...

Thank you very much, the link was for Access 2003 but I was able to find similar info on acc2000. As for CutePDF I agree it's a good solution but we can't install that due to company restrictions. Your answer was very helpfull, thank you again!

I completely agree with what you said but I'm unfortunately limited here in what I can use. We have Access 2000 and am unable to export to pdf. Snapshot is far from my first choice but it's the only one that allows me to send charts as well as data on a report. Since everyone who uses the...

Hi, I created a nice fancy report for my team, I have a button on a form that exports it to a file. Right now when I click it it gives me the default option box allowing me to choose what type of document I want to export (HTML, EXCEL, text, snp, etc.) How do I set this to be Snapshot...

Ok I tried something for fun (Thanks to JANR for the idea), here what I tried : Dim ddiff As Integer ddiff = DateDiff("d", [StartDate_rForm], [CompDate_rForm]) If ddiff <= 2 Then MsgBox "55" Me.txtReq48.value = 55 Else MsgBox "32" Me.txtReq48.value = 32 End If And the message boxes return...

That was a good idea but it returns the same value of -1

it returns >>>9/16/2010

Hi again everyone, From my point of view this should work... it doesn't. I have 2 date fields on a form (StartDate_rForm & CompDate_rForm). I simply want to return a value in a text box if the diffrence between the 2 dates is less than 2 days or more. Here's my code: Private Sub...

That's a pretty decent solution but I don't really want my users to specify what they want. Let me explain in more details what I have. Basically I have an entry form that records the date we received a request and the date on which the request was done and filed. Then I have a form...

Hi everyone, I know that this has been discussed at large in the past and I have found great info in the past threads but none that answered my dilema. I have a query, the criteria is pulled from a form's combo box. Here's my code Field : Treatment Time...

You're 100% right about that, hence why I'm looking for a way to have a local backend that syncs/links to the main backend.

Hi everyone, I'm having speed issues with my database. It's a small DB with about 20 users nationwide. The server is located in Toronto and users from Toronto, Montreal and Vancouver use it. The problem is that it's a big server and there's alot of network traffic which makes running queries...

That's excatly what I needed!!! Thank you thank you thank you!!!

Hi everyone, I'm having problems with a chart I'm creating. I have 2 queries, 1 SQL multi-table query and another that runs from the multi-table query results. The second has form filters based on drop boxes, the allow the user to chose what they want to see in the chart. Both...