Search results for query: *

Thanks for your help M8KWR, I really am restricted to generating the SQL clause on the fly as it is particularly complex. With a huge selection of fields for people to filter on a number of tables. The quick n easy solution for me was to keep it using a datasheet form and running the...

Sure, I was thinking somewhere along those lines. What would be the best way to build an SQL query at run-time and save it so it can be exported? Thanks for your help

Hello, I need to find the best way to export a selection of data to excel. Using the docmd.transferspreadsheet command doesn't seem to be an option as I need to export filtered results. At the moment this data can be viewed on screen using a form in data sheet view. This is important as I...

Thanks for the help, its the late binding that I needed to get it working.

Hi, I've got a database that uses the outlook object to add calendar entries and send automated e-mails. This works fine in Access/Outlook 2003, however I need it to support Access/Outlook 2000 aswell. In the project references I have the Microsoft Outlook 11.0 Object Library Microsoft CDO...

I assume that both the EmpID fields are the same data type also? Try changing the DLOOKUP to:- DLookUp("[Wage Rate]","tblEmployees","[EmpId] =" & Forms![HoursForm]![EmpId])

Did the DLOOKUP return the correct value? Have you tried editing the data field in the query manually through dataview? Some queries won't let you edit related records. It shouldn't really matter whether you lookup in the table of in the query.

You could try opening the object in edit mode and see if an error is generated that you can capture and trigger an error message:- DoCmd.OpenForm "Form1", , , , acFormEdit

Are the data types in both fields the same? The data type for the wage fields in the Employee & Hours tables need to be the same... Try running: MSGBOX DLookUp("[Wage Rate]","tblEmployees","[EmpId] =" &[HoursForm].[EmpId]) And see if it returns the value that you're expecting. This...

Yeah I think DLOOKUP is what you need, something like. tblHours.wage = DLOOKUP("Wage", "tblEmployee", "[EmployeeID]=" & CurrentID) Should be able to put that as a control source property for a txt box etc. Where CurrentID is whatever your using to specify which employee its for. If CurrentID...

Are you using 'OR' or 'AND' between the two field criterias? Have a look in your SQL view and check this, sounds like its searching for:- ByLine1 = Like "*" & [Forms]![QBF_Form]![RepName] & "*" OR [Forms]![QBF_Form]![RepName] is NULL AND [rather than OR] ByLine2 = Like "*" &...

From my experience the msgbox command seems to halt execution of code until a user response is given. You might be better off using some customised forms with no borders etc, that look like msg boxes. Then the second form could have its own timer property set. Just a thought

When I try and access the url it prompts for the username saying "connecting to: exchange.domain.co.uk" whereas in my test environment it shows "connecting to: domain.co.uk" All the IIS settings point to the domain and not the computer name. Could this be anything to do with the problem??? Thanks

Sorry, forgot to include - No we're using Symantec AV with the exchange agent, have tried removing this but it doesn't seem to effect the problem. Thanks for your help Regards

Hi again, Sorry for not getting back - i've been off on annual leave. i've looked at the article you mentioned above before, it seems to refer to problems relating to ISA, we're not using that product. Also we haven't enabled FBA yet, want to get it working normally first. do you have any...

Hi, No can't access it internally at all (we don't need external access), it just prompts for user name 3 times then says error: access denied. I haven't enabled SSL yet, wanted to get it working with Basic auth first. I have tried using various username combos i.e. username@domain.com...

Hi, Thanks for your reply, I have just checked all the settings in IIS and ESM and they appear to be all correct. The only thing that looks out of place is that we don't have the Exchange-OMA vdir, is this a default folder for Ex2003? We don't really need to get the mobile access working just...

Hello, Bit of a wierd one here, OWA stopped working shortly after it was installed. Haven't had time 'till now to get it sorted out. I've been through so many articles online and none seem to have my specific problem. We are part of a larger exchange organisation, we are a sub domain inside...

Well I'n new to CGI but I beleive I can use VB, Java & Perl to accomplish this? Do I need to install something to use perl? I'm running Abyss X1 web server on Windows 2003, only cause I didn't have my I386 folder handy to setup IIS. Plan to migrate soon.

Hi All, I'm an experianced VB & Java programmer but until now haven't really applied this to web pages. For a charity event I want to put a comment box on our site for feedback. Only to capture Name & Comment fields > preferably to store the info in a text file. Is CGI the right route to be...