Search results

Sorry if this has been explained elsewhere but I couln't find it. I have a data editing form where I use several combo boxes to select the data in an Access back end. In Access I can simply create a recordset of the data I wish to edit then set the value column in each combo to the value in...

I have been writing apps in Access since version 1, mostly to track business processes for small companies. By now I have sort of got my head around VBA etc. I have now managed to use .Net as a front end to an Access back end. The advantage of this being that the client does not need to own a...

I have spent many hours experitmenting and searching without result so maybe someone here can help me. I like to have my reports appear to users before they print them. I hide the main form of the app and have the report appear on the screen maximised. I also have a customised toolbar to enable...

Hi All. I have searched forum without success so hope someone can help. I am using SQL server as back end with an mdb as front. I have several pass-through queries which use views as the data source for list boxes. Everything works fine except that money type fields do not appear in the Access...

I have searched the forum but can't find any help. I have an application consisting of front and back ends being used by quite a few clients now. As a result of feed-back, I have made some improvements to the app but these require changes to the structure of some of the existing tables in the...

Hi Everyone. I am building an app which will be used to administer a small company which has several mobile service engineers. Everything is fine. A fairly standard sort of job until the client asked for a screen showing each engineer for a given day with a bar graph showing planned start and...

I have probably designed and printed thousands of reports but this one has a mind of its own!!!! It is designed to view and print in Landscape. Nothing strange in that except this report, and only this report runs off in landscape then somehow or other, reconfigures itself so that next time it...

I use a technique of building a local temporary table to be the source of various reports. I create these using ADOX and things work well. :) However, I have a P&L report that needs a table with the default values set to zero when the the table is created. Currently I run code to fill the...