Hello everyone, I'm running into a major problem with Access 2007 when importing a text file into the software (.txt format). I have never had a problem with...
Dear All I want to populate a unbound listbox from an unbound textbox onChange event, both the controls are on same form, the list box contains product name &...
Hi all! I have two queries which in the next step are joined in a union query with other similar queries. These two are from the same tables and joins but one...
Good morning/afternoon all, I am going through queries trying to simplify and have come up with some question re the best way to do things. I had many SELECTs...
Anyone seen this before? I made a change to an Application, tested it and just before releasing it to testing (I know, bad Idea) I changed: CurrentDb.Execute...
I have imported 1 Excel spreadsheet into 1 Access table before. Now I am being asked if I can import 1 Excel table into two tables. Actually the user does...
Ok, I have a user that wants the following to display in an email. I got everything working except now they want to see the field title (not a label) bolded...
Hi all, On one of my forms I display a label if there is a related record in another table. Is it best to use DLookup vs create recordset and get recordcount?...
First, I am new to this group, but I am also relatively new to MS Access. I am trying to build a database that I can use to search and create reports with....
I have a database that uses a front end that is linked to an on line data source. I use a query to make a table so that I can make reports from fixed data. I...
Hello, Trying to open another form from my primary form by clicking a button I get the following error message from Access , which I cannot figure out how to...
I'm wondering if it is possible to have too many Check Boxes even though that is the only way I can envision it. By way of an easy example, let's say I want...
Hi I would like to disable the F11 key for some of my users when they log on. I have already disabled the ribbon (thanks to a previous post!) by adding code to...
Hi 2 of my tables are called company and shop. I have a table (I'll call it Main) which has many fields, 2 of which are called company and shop and these 2...
I have a database user that wants to email facility information to each individual facilities contact person, using Lotus Notes (hence, Word mail merge won't...
I have a table in which 3 columns are calculated based on other columns in same table. I also have a report based off of this one table. The problem I am...
Hello all, I have built a query using the pivot table format. Having filtered some data and saving it, when I create a report based in this query or copy it...
I am trying to count how many times a category has some information in it such as a TYPE column that has an M or F in it, I want to know how many times M or F...
Hi I have hidden the ribbon for certain users. If they open a form in form view they can right click to give them an option to change to datasheet view. If...
I am new to programming in Access. I am using Access 2010 and would like to be able to print the current record's data to a specific report, without printing...
Got that message today. So I went and cleaned up the forms, deleting quite a few ones that had been redone and were no longer being used. But that didn't...
Good morning! Would you take a gander at this to see what's giving the "syntax error in from clause" message? I know I should be able to figure it out but...
Hi All, I have a Quote Entry form with a products sub-form. When run in Access 2007 the tab key goes from one control to the next and then to the next record...
Is it possible to pass the value stored in a variable to a criteria box in a Query designed using the Query Design Wizard? For example, let's say I have an...
Here's what I want to do: catalogue the properties and their values in an instance of a class. Here's why: I am using a custom class to perform a complex set...
Dear all, Can we open network drive with password thru vb code instead of go to window explorer and type the password ? Thank you in advance for your guidance....
Hi I have created an embedded macro in a form for the first time - basically a series of If / elseif commands. I am trying to add an outer if statement to the...
