Recent content by jt643

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...