access 2010

Hi all, I'm trying to extract data from an Access DB into an Excel user form (as the intended users will not all have MS Access). The access table (TblData) has multiple rows and fields, and the SQL query I have created will search the 'CaseRef' field for the value the user puts in to the...

Hi Guys, I made a Database already, I need to make a button in Access, Whenever i will press that button it will pop up the to select the files to import and then directly import it. IF thats not poossible then whenever i press the button it will check the folder if i found any new file it...

Hi Guys, I am trying to Import the the files from Excel, but when i am appending the second file its not showing the records or data in sheet. Any Idea whats wrong? Thanks

Hi, I have an excel workbook that allows users to enter information into a form and send it to a back-end Access Database. It works just fine when it is in a normal folder but I have posted it to a SharePoint site and now notice that when the information is entered on the form and submitted, it...

hello all, learning Access and I'm stuck. Is there a way to create a calculated field to find the last value in a row of a record? What I have is an employee DB so the unique is the employee. along with other data, i have management hierarchy to the top as fields manager level 1, manager level...

I am sure this is fairly simple but I am having trouble getting started on this. I use a Form to invoice clients which includes the field [Billing_Month]. What I'm looking to accomplish is this. When I create a new invoice and enter the [cboAccountID] value, the [Billing_Month] field will...

Hi All, I am trying to match headers of different files and copy data.If the one of the header is not matched then a new column with the non matching header should be created and the column has to be copied Ex: file1.xlsx has AA BB CC as header file2.xlsx has AA BB DD EE as header...

Hi, I am working on streamlining some of my database processes, one of these processes is stock control. I want to run a query where the criteria changes in a delete query based on what is entered in a form. This delete query is going to be used as part of the stock control process. The query...

I am trying to get data more easily usable in access when I import from excel. the report is from a webpage and is downloaded in an excel spreadsheet format. the spreadsheet has a heading that takes up the first 9 rows and a footer that is the last 3 rows. I had some problems with the import...

Hi, I have got a data input form in access, and i would like a yes/no message box to appear when the "complete order" command button is pressed. The command button is linked to a macro which runs a set of queries in the completion process. I have tried writing VBA code to do this in access...

Hi, I am currently looking at improving a form that i have created which has the purpose of entering stock orders into a table so that they can be stored and then used to actually send off to suppliers. The fields that are filled in manually are, Product ID, Product description, Price...

Hi, I have a table that is updated when an order is paced in a form. All of my tables have the appropriate relationship link. Due to an order being an individual record, the same item can be ordered many times by different people. I have 20+ items that could be ordered, all with their own...

Hi, I am currently creating an inventory for stock. I have got a product table which has a stock field and i have a order table which will be updated through both manual input and order reports that will be pulled through from excel. What I would like to do is to subtract the stock away in the...

Hi, I am creating an inventory for producing orders. I have a supplier table and a product table at the moment. I would like the product table to show the supplier name based on the supplier code in the supplier table. I have created a relationship between the primary key in the supplier table...

Hi, Is there a an argument to input into the criteria that will search for any record after a certian date? Thanks in Advance, HeyYouYesYouNoNotYouYou

Hi I'm actually trying to capture the system logout time in a field in access. The below formula is I'm using and I'm getting the Compile error. I'm using Access 2010 and exactly which reference object should I chose from tools Private Sub Logout_Click() End_Time.Value = Now() If MsgBox("No...

<tbody> I have been beating my head against the wall because I can't figure out what is going on. When I try to import data into a table I am getting "Field "F42" Doesn't Exist in Destination Table" error. I have a "client lists" table...

Hi Masters, I have a text linked file in access, i want to create a table from link file with a new blank column in last with TEXT intiger. i did it by Added_Column: (""), it put space in every cell and when i update data in that column by null criteria, it not update, mean not find any NULL...

Hi All, I never use access but have to create a field in a table with a formula in it. The formula works fine in excel. Does anybody know how to change it to access? The Excel formula is...