access 07

I have an Access 2007 database that has two related tables (let's call them [PARENT] and [CHILD]). I have created a form that shows the fields of the [PARENT] table and below an embedded subform that displays the fields of the related [CHILD] table. One of the text fields in the [CHILD] table...

I'm using a form to put criteria into a query. I'm using date ranged but if i input date range <code style="margin: 0px; padding: 1px 5px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New'...

I wasn't sure whether to post to the Access or Excel forum since I am using Access to call Excel. Went with Excel since this forum has way more viewers. Sorry if I got it wrong. The following script runs fine the first time I click the command button on an Access form but after I close the...

Hi, I need a favor from you guys, I already made a button in Access, I need to import the files from excel through that button on Macro, whenever we click the button it have to be import the excel files in database by matching the two columns. here is the example Database: Col A Col B...

Hi all, I am trying to run a VBA code in Access to open an excel file and export some data into it. This has worked before with Excel 2003. I had to recently migrate to Excel 2007 and I am getting various errors one by one, but at this point I am stuck at this particular step of opening an...

Hi - I am creating a custom ribbon in Excel to perform a variety of analysis on a dataset that is refreshed everyday. The first button I have included on the ribbon is one that I would like to import data into an Excel worksheet from an Access table. I have the following module, however, I am...

Hi - I have a main page form in my database where the user is selecting the month end date for which they are using the database for. I have established this as a public variable "modeldate". Once the user selects the date the variable is stored and I have verified this using the debug.print...

Hello, I have a large amount of data in an excel spreadsheet (over 22K in rows). I imported the spreadsheet into access as a table and made some queries, but the problem is that I'm not sure how to incorporate the much needed excel formulas into the queries to analyze the table. Here is one of...

Hi - I am looking to concatenate two variables, both are numbers, with a hyphen in the middle. Right now I have variables x1 and z1 and I want to create a new variable, b1. I have tried all different approaches and each time Access is taking the difference of the two variables, whereas I just...

Hi - Is it possible to reference an established public variable in another module other than the one it was created in? In my database I have a main form page where the user selects a date from the calendar. The way that I have this set up is: Public modeldate As Date 'Model Date Select Sub...

Hi, I'm very very new to access vba. Here's what I did(I'll explain with an example) - (NOTE: If status is inactive then column 32, 33 should be "No" and red. If status is "Active" then only next strings should be searched in column 13) Example - columns are - Status(4th column), Group(13th...