Search results for query: *

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?

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

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

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

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

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

I may be asking for the impossible. I have a subform that displays as a form that mimics a datasheet - in other words, I have the text boxes meeting each other with white background and black text - so it looks like a datasheet. The three colomns are 'Category', 'Selection', and 'Order'. What...

I have a button on a form that will open another form to allow users to edit a record. That original form also has a check box to tell the user that the customers have 'signed off' on a certain item. What I want to happen: When the user clicks the button to open the next form, the code looks...

I have been working on an issue in thread705-1130455. It now appears that the issue is not with the VB or References, but rather in my queries. In the VB, I define: Dim UserID As String UserID = Environ("USERNAME") I then run queries that also have criteria of: WHERE...

I have been working on an issue in thread705-1130455. It now appears that the issue is not with the VB or References, but rather in my queries. In the VB, I define: Dim UserID As String UserID = Environ("USERNAME") I then run queries that also have criteria of: WHERE...

I have been trying to resolve an issue I posted in thread705-1130455. One of the suggestions was to export all of my objects to a new database. As I compiled the code within the 'new' project, the compiler keeps giving me errors on code that has been working fine for over a year: Dim...

I posted a similar thread that I ended up thinking I found the solution to. (thread705-1121179) However, the error is happening again. When a user clicks a button that runs either a function or a macro that references the 'Environ' expression, I get the following error: Run-Time Error '3085'...

I want to provide VB code that will allow users to simply click a button and export an Access report to a .TIF file that will ultimately be pulled into an Excel spreadsheet. I will have two files that will be placed on one ledger-sized spreadsheet in Excel, and I want to make it as...

Does anyone know what could be causing my computer (running Windows 2003 Server)to display a 'critical battery alarm' when it is a desktop? I have it hooked up to a power surge with battery backup, but we have not had any power surges to my knowledge. Thanks.

My database has been working fine until this weekend. I utilize the following code to extract records from a temp table: UserID = Environ("USERNAME") Now, I am getting errors saying either "Undefined Function 'Environ' in Expression", when in the form view. I used to be able to hover my...

I have just learned how to group and make a report with multiple columns today. It is awesome, but I am having some inexperience problems. I need to print the report on a Ledger size paper and keep it to one sheet. I want to split my data into four columns formatted to go down then to the...

I have a table with a field that is a checkbox control - 'Order'. When the user finishes their selections, the master selections table will be queried in VB to extract all records that have been checked to order and will compile them into a 'FinalSelections' table. I can not get past the code I...

I am having a tough time figuring out the correct syntax to pull back all records from a table that have a yes/no box checked on a table. I thought the following would work: Set SelTotalTableDb = CurrentDb Set SelTotalTableRst = SelTotalTableDb.OpenRecordset("select * from COSelTotalTable...