Search results

Thanks for those suggestions. It was the SSMA_TimeStamp field so I just selected all other fields in query and its worked fine!

Hi, I've used views for two queries in my DB. It runs in SQL Server fine and also can run as a PT query in MS Access. But I get ODBC call failed when I try opening the view in Access. (Other views are fine.) What is going wrong here?

I implemented views. Also appreciate the info about how it updates!

Hi Hope someone can help me find clarity in an issue I am having with a dynamic report. For each row of data, I am calculating the Current week, month to date (MTD) and year to date (YTD) values. This works fine where the same month and year are throughout the current week. However if I would...

Thanks for that advice. I've tried it and it seems to work very successfully!

Will a view be updated automatically ?

Hi I have the following query as a form recordsource. It run fairly quickly on Jet but now that I have moved to SQL server it crashes the DB. If I would convert to PT it would mean the form is not editable. Are there any alternatives? This is the SQL Server version: SELECT * FROM tblorders...

thanks I think I've sorted it now.

Design view here - just renamed columns for easier user comprehension.

I am having trouble with a report based on a query. It is not showing all values. There are no events in open/current/load of report to filter or change the data. What is going wrong here?

Thank you. I am having trouble with writing the stored procedure to do the above. Can anyone help me? CREATE PROCEDURE test1 (@SRCH VARCHAR(50) ='') AS BEGIN SELECT qryTransSearchAll.fldOrderID AS ID, qryTransSearchAll.fldDblGlzSysRef AS Ref, qryTransSearchAll.fldOQBRef AS [QB Invoice]...

Thank you @CJ_London Can you advise re stored procedures - i am assuming these are defined in SQL Server. So how are they accessed on the MS Access FE? Can you point me to more info on this please

Hi I have a form for searching many records using a search string in a textbox. The results appear in a listbox. We used to use the textbox string as a parameter for the listbox rowsource but now we have changed to SQL server and using a pass-through query for speedier results. So we can't use...

Wow working now. Thanks for your help

Hi I have code in my DB which sends message through outlook. It has worked fine until now - it even seems to be working on most machines but when I try testing it on one computer I get 'error method not supported by this object'. I debugged to find it was the .body = strBody line so when I...

Thanks - very informative. I actually thought through the best way for my purposes - I don't need the autonumbered columns as I will be using the student names for headers and each is a unique record. So instead I iterated through the base query to find the names of the students and assign as...

@Pat Hartman looking at your sample DB now. Its amazing how generic the code is! Is the whole dynamic column process happening in the report load event or is there other procedures involved?

Another disadvantage is you can't automate any events directly on the fields.

Thanks @Minty your method seems to suit my needs best. Only issue is that the query shows as a datasheet including navigation buttons - any way to remove or cover this?

Sorry not sure what you mean - I pulled the query onto the form but it brings up the wizard to create a subform with the query as the record source. This does not show up at all in the form view for some reason??