Search results

I'm not quite sure how to go about this. I am wanting to make a query that compares the price of one part to the price of various other parts in a matrix. Example: 60 70 80 10 $20 $25 $30 $40 20 $30 $25 $30 $40 30 $20 $25 $30 $40 40 $25 $25 $30 $40 50 $40 $25 $30 $40 So...

I'm trying to add a bunch of reports to a combo box. Here's the code: Dim varReport As Variant With CurrentProject For Each varReport In .AllReports If Right(varReport.Name, 1) = "Z" Then cmbReport.AddItem varReport.Name...

I have two forms. frmStartup frmMain The startup form just has a logo, db name, version, and an exit button. The code for the exit button is simply: DoCmd.Quit acQuitSaveNone The frmMain has all of the DB stuff for users. This DB has the option of using a local database if the user isn't...

Is there a way to calculate where to put an image based on the screen size the person using a database has? I'd like to position a logo in the top right of a form when it's maximized, based on the size of someone's screen. Is this possible?

Not sure where to put this, so trying here :) Okay I have a query that combines information from two tables and want to make a Pivot Table with the data. Here is some example data: PartCode ProductType TransDate ActualMT ForecastMT 503220 OTHER 10/1/2008 2.7255 3 503226 OTHER...

I don't know if this is possible. I need to filter on whether the value of a field is "BIN/" or "BIN*" or various other things. The data is from a mainframe system, and whoever created that was wonderful enough to allow these characters in text fields.

Nevermind..lol...this was a stupid question.

So I am working on a report builder for my current database. Basically it will let you choose a variety of things which will generate a SQL WHERE clause to use to modify a base report prior to opening the report. So I have several things that I will be able to filter by. E.g. Product Type...

I have a DB which has several tables that I need to be able to combine into one for reporting. I have a sample DB that I have posted. Here is the basics: Tables: Part Customer Tier Region CustomerDiscount TierDiscount RegionDiscount Part table holds information about parts including...

Been working too much, can't figure this out. I have a part table that has info on parts. I need to combine this with 3 other tables that have various discounts. Each part can have a discount for a Region, Tier or Customer, or all three. There are multiple Regions, Tiers, and Customers. I'm...

Used to working with VBA in Access. I am used to having the ability to trigger code happening if anything in an option group changes. Say I have radio buttons or check boxes within an option group. I could use the OnChange event of the Option group which would trigger code whenever any radio...

I have a few people getting this error in my database. Happens when they try to save a record and then get a new one. I have searched on Google and not found anything that seems to be related to my problem. I'm just curious how to get around this error. I don't mind if it pops up, but I want...

I thought I had this handled...however it seems that it's not quite 100%. I have a database that has a single user form. This form, upon loading, has a recordsource which selects only those records which have two fields marked as "No". The fields are named LOCKED and COMPLETED. They are just...

I need some help getting random results in a query. I have this so far, and it works, but it is slow. SELECT TOP 1 tblMain.Field1, tblMain.Field2, Rnd(tblMain.Field2) As Expr1, ... FROM tblMain WHERE tblMain.COMPLETED=False ORDER BY Rnd(tblMain.Field2) DESC; This does a great job actually...

Okay so I have a form that is causing problems somehow. I have a data table that has currency values in it. There is a field on the form that adds and subtracts some of what is entered in order to determine if an account can be archived. Basically it's for following up on some collections...

I have a DB with employee info - it has info on days off. I would like to create a report in the form of a calendar which would show the current month and put down the names of employees who have scheduled time off - so people can see at a glance who from their team is off and when. Does...

I have a spreadsheet, and I have some formatting which is done to remove text lines after a certain point, etc. Anyway I want a test to count how many rows start with a cell that contains a number. This is to be used as a control so as to compare the number before and after the program is run...

I have a file which has account numbers. There are duplicate account numbers throughout the sheet - 2000-3000 rows of information. I want to write a program which will find all the duplicates, mark them for deletion, and then remove the rows. I can do everything except find the duplicates. I...

Here is the code that I have so far: Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim strVar As String strVar = [Forms]![frmDateSelection3].[QueryDate].[Value] strSQL = "SELECT * FROM qryCustInfo WHERE ((qryCustInfo.[Date Entered System])=#" & strVar & "#);" Set db =...

We have about 170 employees here. Currently we have probably 10 or so databases - they are Access based. I am working on a project to combine the 10 into one - there will be some duplication which is removed due to having them all centralized (date entered/completed fields, user initials...