Search results

I have a form that is showing data from 1 table. That table has 12 different fields on it and I want to be able to filter based on selections I make in a combo box in the header of the form. The filter string must be dynamic enough to allow filtering based on 1 criteria selected, or multiple...

I have a user login form wherein my users authenticate their employeeid as well as their person PIN. If the user authenticates with a valid username/password combination, then the employee id and the role (permissions) for that user are stored on the form and it is minimized to stay open. If...

I have a module like this: Public Function DisplayImage(ctlBrowserControl As Control, _ strImagePath As Variant) On Error GoTo Err_DisplayImage Dim strDatabasePath As String Dim intSlashLocation As Integer With ctlBrowserControl If IsNull(strImagePath) Then ElseIf Left(strImagePath...

I have a table that contains: item | quantity 123 | 1 456 | 10 789 | 4 I need to get this data listed into a table that just has item and for it to look like this: 123 456 456 456 456 456 456 456 456 456 456 789 789 789 789 I understand and have accounted for the obvious primary key issue...

I have an Access front end linked to a SQL Server 2005 back end via ODBC. I have anywhere from 1 - 5 concurrent users in the DB at any given time. I am having some users begin to complain that their Access file freezes every time another user is logged in and has a particular form open. They...

I think I almost have this recordset functioning properly, but I'm a little amiss. Can anyone help me out? I'm trying to update several fields on a form from a recordset. This is what I have: Dim strSQL_AZ As String Dim db As DAO.Database Dim RS As DAO.Recordset Set db = CurrentDb()...

I have a section of VBA that is working almost 100% properly, but I'm having trouble with something. When I double click on a property within Form A, then Form B opens and much of the data is filled in based on the values in Form A. I recently added two properties to Form B and just like the...

I posted on Friday a very similar issue with a recordset. I've used most of the recordset portion of that sample code, so I don't think there's a problem with that. I think there is some problem with how the SQL statement interacts with the recordset, but I don't know recordsets well enough to...

I have a variable I need to populate with a value and in turn populate a field on a form with that variable value. The value I want to set the variable to is the result of this query: SELECT TOP 1 WarehouseLocation.LocationCode FROM WarehouseLocation WHERE (WarehouseLocation.CurrentUnits <...

I have a field that I need to perform and update statement to. I need to replace any instance of quotation marks (") with double quotation marks (""). For this I know I need the replace function, but I'm not clear on the quotation mark portion of the syntax. Here's what I have...

I would like to limit the results I get in a particular field of my query to 30 characters. The field length currently has a length limit of 50 characters, but I need to import the results of this query into a different database and the corresponding field in the destination database only has...

I have a situation where I'd like to import multiple files into an access database. Most of the VBA I'm okay with, I'm just new to using loops, so I'm hoping someone has a good ability to help me with looping this function. I'd like to start out by opening a dialog box that allows the user...

I transferred the contents of my .mdb 2003 version of access to the newer standard of .accdb. Most everything is working except a few pieces of code. I think it has something to do with object reference libraries but I'm getting an error when I try to add which ones I think will fix the...

I am having a difficult time with some VBA code running a replace function. Specifically, I'm trying to update a field that contains gender information. The information is contained in my database as follows: "Womens". HOWEVER, I need to run a VBA function to replace all instances of "Womens"...

I have a set query that displays items that are in a certain status. Its more like a SQL server view if you're familiar with that. My back end is a SQL server 2005, and Access is my front end. Here's my problem. So, the items that display in this query are those that meet certain criteria...

I have a bunch of code that was written in 2003. I have since "upgraded" office computers to Access 2007. Now I am having issues running the same code that has worked without problems for ages. An example: Date() doesn't work in VBA code or update queries. I'm given the message "Run-time...

I am comfortable with VBA and/or creating macros. I have an Access front end that users interact with. I have stripped away the database window so the only visual thing is the switchboard from which users access menu items. Problem is this. For some reason when we upgraded to Access 2007, we...

I have a form where I am entering values into several fields. These fields will contain numbers that will need to be inserted into various inventory account tables to show inventory transfers from one allocated location to another. For example, I have 10 pcs allocated to 4 different channels...

I have created a form and the default view is Continuous Forms. I am using the Header portion of the form to put text boxes that act as column headers. Many of the column headers are abbreviated. For example, "BR" really means "Buyers Remorse", and then there are 14 more different codes. I...

I have a query that is used to generate some shipping labels. The order that those labels are generated matters a great deal because we use those shipping labels to go through our warehouse in an orderly fashion and pull what is on the list to be pulled. The data in the query is exported and...