Home » Access » Page 4
Filter subform based on main form combo.column.(x)
Access
This has to rank up there with one of the stupidest problems ever, but I've been staring at it for several hours now and nothing seems to work.
Problem: I want to automatically filter a subform based on the value of a combobox in the main form (switchboard). But I need to filter based on column(1), not .Value
Main form: Switchboard
Field to filter by: comboUserName4 columns.Col

Pulling together several tables
Access
I am a bit of a novice with Access (am running Access 2010), but it seems within my company I am the most advanced user, so am a bit stuck on something and don't have anywhere to turn to! :banghead:
I have datasets in tables for some price data, which is monthly.
Each month there is a list of unique ID codes for the products ("CAP Codes") and then a price for that product

Searching for records - statistics
Access
I have a database which has numbers for different statistics and i would like to be able to search, for example, the past 10 weeks and find out how many time a certain number has been recorded. Any suggestions ??

Dlookup with multiple criteria -!!!
Access
I have this
Code:
If Not IsNull(strCount = DLookup("[Number_Of_Records]", "All_Booked_Callbacks ", "[CallBack_Date] =#" & Me.CB_DAte.Value & "#" _
        &

Graph X Axis Spacing?
Access
This is on Access 2010 and graphing still sucks ...
Just trying to do a line graph.
My X Axis just will not auto space itself for the available data meaning it is showing most of the data (on the X axis, Y axis is fine). Theres tons of room as the space between X data points can be shortened a good bit if I could actually tell it to do it.
Am I missing an option somewhere? I ho

Filtering using multiple checkboxes
Access
Hello - I'm having a rough time finding information regarding filtering using multiple check boxes that are not part of an option group. I have 4 "sets" of check boxes that can each have multiple selections made.
For example I have:
12 check boxes for each month
6 check boxes for a selection of years
6 check boxes for order types
5 check boxes for order comp

RECORDCOUNT not working
Access
I have a table called tbl_courses. This currently has 3 complete records in it (3 courses).
I have a form with a textbox; the textbox is called txt_course_total.
I want the textbox to show the total number of courses currently stored.
I wrote the following:
Code:
Finding duplicates in a table and recording values in that record.
Access
Hello all,
I've been looking everywhere to find a better way of finding duplicates in a table and then recording and adding another value in that record together.
Let me try to explain better.
example:
I have a table that has 2 columns "Name", "DOB". I would like to find all duplicate "DOB" and add all of the "Name"'s together.

local area connection
Access
Hi All,
I'm trying to monitor my internet line. I can now successfully ping the line (see threat (shell function)and get the milli seconds back in my VBA program and hence in my Db. now the next challenge is that I would like to know how busy the line is at the ping instance. I tried to find a measurement inside my modem software but couldn't find one. So decided to switch to the next be

Possible to concatenate multiple records grouped by date? (AC2007)
Access
Hi guys,
I have a rates table with 3 fields : [RateDate], [CurrencyID], [FXRate]
I also have a currencies table with 2 fields : [CurrencyID], [CurrencyCode]
Where [CurrencyCode] is just the 3-character currency code (i.e. EUR, GBP, USD etc.)
The rates table uses a composite primary key across [RateDate] and [CurrencyID] - i.e., there should only be one unique record for ea

Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .