Search results for query: *

Perfect thanks to both of you!

Is there a way I can autoupdate or refresh my linked tables via VB or within Access so my users don't have to go through the 'Linked Table Manager' each time?

Brilliant! Thanks PH.

Remou - you have already earned a star. I have had a brain cramp. My VB gives me an error on the following statement: Set Report2Rst = Report2Db.OpenRecordset("select * from DrawTotals WHERE check_no_ = #" & ReportRst!check_no_ & "#") I know it has to do with my syntax on the select...

Thanks Remou. So, my 'Field' value in my Select statement would be Val(check_no_), and that would tell the SQL statement to return that field as a 'Value'?

Thanks Remou. Where would I insert that? The query, the field format of the report...?

I have a check_no_ field from SQL Server that is text. I am pulling it into Access via a query. From there, it will populate several different tables culminating in a report with the Check Number. I want to find a way to make sure that on the Report the leading zeros (i.e. check_no_ =...

Thanks Remou. I'll give that a try. Rules of Access or company rules??? I'm kosher on the latter.

I want to take the field from a Report Footer that stores the numbered results of a calculation on the report and transfer that value to a field on a table in my database. I am attempting the following: PreviousRst.Edit PreviousRst!PreviousDraw = Me.TotalChecks.Value PreviousRst.Update...

I am trying to determine whether to use FrontPage or Access for a VERY simple web site. I have never done anything with Data Access Pages. What I want to do is create a simple web page with 'username' and 'password' controls. Based on their log in values, I then want to open a report (via the...

Putting the grand total in the report footer worked great! Thanks Remou!

Remou - that worked great! However, my report now shows a line under each record that says: 'Total Checks to Draw' = $##### (This is the label for the field I identify the total field as.) Is there a way to only show that once at the bottom of my table?

I have seen similar threads but none speak specifically to my inquiry. I have a 5 field report that varies in the number of records: Chk_No Chk_Dt Chk_Pye Chk_Dsc Chk_Amt 1234 10/31 Trade Payment 300.00 I have a field in the page footer that I want to contain...

I have figured it out. I had to change my 'default database' to be the one in particular that I wanted.

I briefly searched the topics for this answer, but I think it is not out there because I should already know this. We have just purchased software that runs on SQL Server. I want to connect to the .mdf databases and then specific tables in that database via Access. I got to...

Thanks to all of you for your help. I understand where each of you are coming from. I am at the infant stages of tapping in to the capabilities of these tools. So, I will attempt the DAP solution since I have more experience with Access and VB. Since most of the people in the construction...

Thanks Jim. The portion that is on the SQL-Server is data from a third party software application our company just purchased. I do not have a lot of experience with it but will be going through training next week. Can users view Data Access Pages on via the web even if they do not have Access?

I am at the planning stages of a project that I need help figuring out where to start. I want to create a web page that will allow our sub contractors to log in and then based on that log in to display a report that will show them their upcoming schedules for new home construction. I feel...

I spoke to Toshiba about this issue. It ended up that I could not use the pen to click certain buttons on many applications. I disabled all startup programs via msconfig, and it then worked. I also had to change the default monitor setting to be landscape when I change the monitor to Tablet...

Is there a reference I need to install or some setting I need to enable to allow users full functionality of my Access database while using the Tablet function of their Tablet PC? Case in point, I was running a user through training, and everything was golden with the exception of not being...