access 2010

:warning:I have recently started my AS ICT coursework and I am having one problem with one of my queries. I need to create an invoice query to show the total amount spent by customers while they stay in a camping site (I will use this query to make a report). I have 5 tables, these including...

Hi All, I am trying to achieve a dynamic value field. What I mean by this is a field in a database which changes depending on a field in another record. For example:- I have 10 records in a table. Each record has a default value of 2 assigned to it. So the total across the 10 records is...

I have a tracking database with I use to put notes in and track different problems. Occasionally I would like to email directly from this database asking quesitons or delivering reports. I have the following in my message text section --- =("Due: " & [Due Date] & [Email Notes]) I would like to...

Dearest Excel Magicians, Wizards and Gods I have a report that was made some time ago (P&L report). It grew to 60mb at this point, and with all the pivots, caluclations etc - well, it got very obese, slow and lazy. I figured out, that I will move all the source data to MS Access database. But...

Hi, I'm completely new to Microsoft Access. I've built a userform and I would like to display the windows ID/logon ID in a text box. Please could you guide me through the steps? very much appreciated Cheers, Anthony

Good morning all... I am attempting to programmatically identify queries hidden from view in MS Access 2010. I understand that there is a hidden attribute (accessibly through the UI by bringing up the properties of the query and VBA with GetHiddenAttribute). That I can handle. There is another...

Hi guys -- brand new to Access -- but making good progress. Trying to NOT use VB to accomplish this (for a variety of reasons). I have a field in our database with five distinct strings, separated by a delimited (a slash or "/"). I've been able to successfully write the formula to parse the...

Hello, I have an Access database that updates weekly. I am trying to run an Excel macro triggered by the completion of the database update (in this case, I want the excel sheet to Refresh after access updates). I have very little Access experience (someone else set it up). Any help with...

Hello, I'm struggling with a VBA error at the following line: marked in bold: Sub test() Dim strDBName As String Dim strMessage As String Dim appAccess As Access.Application Dim vartest As String Dim hd As String Dim hf As String Dim databasename As String databasename = "test.accdb" Dim...

Hi, Anyone please helping me!!! I'm very newbie I've been create MS access and want to import file by browse and select file to import. I have 1 text box name "Text01" (will show path and file name to import) I have 1 button for browse file name "btbrowse" (Browse to select file) I have 1...

I'm attempting to find a way for Excel to write to an Access database and for it to work on PCs that do not have Microsoft Access installed. I have found some code here and on other sites, however, it only works with older versions of Access and we use Office 2010. We currently have a CSV file...

I am trying to get a report to open into Preview mode with the latest record, but I am having trouble. I can't find anything online that will help me figure out why this issue is happening or how to fix it. When I open the report, it shows whatever the last record is (based on ID). In this case...

I am struggling to find a solution. I have a table that I log all my customer transactions (tbltransactions). This includes all invoices and payments, each being their own transaction record. When a customer sends me a check, they write the invoice number on it. What I am trying to do is...

Hello Everyone, I have been on the web searching for answers and I just can not find one that works (I'm sure it is something I am not doing right) I have a table in Access called TBL003_Combined Data that has the following columns: UPLOADED REF ID QTY PART NUMBER ITEM DESCRIPTION SHIP TO...

Here is the code I have, I looking like it works, but it get suck in an endless loop of some kind, not from the do while. It looks like it is how I have set up the ListBox. Help Set dbs = CurrentDb Me.ListBoxVich.RowSource = " " Me.ListBoxVich.ColumnCount = 6 Me.ListBoxVich.ColumnWidths =...

Hi, My goal is to create reports from Access that contain several different hyperlinks. I am using linked tables at this time as I am only testing the sytem as yet and still want it connected to the original data. I have four original tables from which I want data displayed. I have done the...

Hi, I have an excel .xlsm spreadsheet used for several years that has many ms query connections to an access db. After the company upgraded to Win 7 \ Office 2010 one of the simplest ms queries will not work. This query simply goes out to an access db table which contains one record and 1 field...

Hi, I have a report that I am automating. The process consists in an Excel VBA Macro that gives the format to some excel files and saves them in an specific folder for access to take these files and import them into the corresponding tables. I was able to automate this process through an Excel...

hi all, i create Web Database type in Access 2010 in "Event Table" there is field called StartTime and EndTime which both of them set as Date/Time now here is the issue!!!!!!!! i found that there is only two option in Format : "general Date and Short Date" is there a way to set the two fields...

Hi All I have been trying various codes to open a selection of one Page workbooks (Graphs) from Both Access and other Workbooks. Access is being used mainly as login and navigation to reports. The below code is the best I have so far, but when opening form Access 2003 , I still get password...