Connecting Tech Pros Worldwide
Ph: 50382041
 
 
Sign In | Register Now About Bytes | Help | Site Map
[ http://bytes.com/adLoader.php?parent=database

Microsoft Access / VBA Forum

Microsoft Office Access database and VBA - Ask questions about microsoft access queries, reports, forms, macros, modules, security, automation, functions, records, mining, visual basic for applications and more.
September 9th, 2008 msquared (Administrator)
The Bytes Tip of the Week - How to Dynamically set the Combo Drop Down List Width
[image]27 Replies | Posted by: ADezii | Last post by ADezii, 47 days ago
This week’s Tip of the Week will clearly demonstrate how you can dynamically set the Drop Down List Width of a Combo Box to the length of the longest... more »
attachment sticky
POSTING GUIDELINES: Please read carefully before posting to a forum
[image]1 Reply | Posted by: PEB | Last post by msquared, 629 days ago
POSTING GUIDELINES Please follow these guidelines when posting questions Post your question in a relevant forum Do NOT PM questions to... more »
sticky
Creating Line or Row numbers on query results.
[image]9 Replies | Posted by: chadh | Last post by ADezii, Today
I have two select queries that need to have a column of line numbers on them. The numbers need to simply be 1 through however many rows there are in... more »
creat an unbound test box on a form to sum data from a simple query
[image]2 Replies | Posted by: sillyr | Last post by sillyr, Today
Hi - My database is using Access 2007. I created a simple query from two linked tables that sums up the data for all records for 11 different... more »
Ticking several boxes in a sub form
[image]12 Replies | Posted by: jacc14 | Last post by NeoPa, Today
Hi there. I am sure there is an easy solution to this and not sure why mine doesnt work? In the main form I have a "closed"tick box. In the sub... more »
Delete Records from a Form
[image]6 Replies | Posted by: puT3 | Last post by NeoPa, Today
Split off from To search record. It works well..Another question is I want to delete records from a form when I try to delete from the form, the... more »
Database Replication Issue
[image]22 Replies | Posted by: iheartvba | Last post by NeoPa, Today
Hi, I already have 3 Databases running: A. they all have the same tables and the same structure B. There is no 1 Master table they are all separate... more »
Automatically fills in a Value dependant on a Combo Box in a Form - Access 2007
[image]4 Replies | Posted by: Kitty001 | Last post by puppydogbuddy, Today
Hi Guys I am new to MS Access and using MS Access2007. I have been fooling around with Access trying to solve this problem for weeks but i just cant... more »
copy record as a new record
[image]8 Replies | Posted by: bluemoon9 | Last post by ADezii, Today
Hi, I am trying to write a code to copy the current record as a new record (basicly, I would like to duplicate the current record). but then when I... more »
Drawing graphics in Access
[image]1 Reply | Posted by: myndzi | Last post by ADezii, Today
I would like to create and print a production worksheet, and store certain information from past jobs in the database for easy reference and... more »
Copy and pasting within a form
[image]2 Replies | Posted by: lrw0831 | Last post by NeoPa, Today
I have the main form where employees enter "issues". Some issues have fields that are the same. My fields are Issue ID (auto) Product Entered... more »
wizard doesn't ask for table relationship
[image]48 Replies | Posted by: chuck gregory | Last post by NeoPa, Today
I'm working with the 2002 (10.6771.6839) SP3 Access program. I originally (earn while I learn) developed a 250-field table. To streamline it, I... more »
Populating a Grid with dates
[image]44 Replies | Posted by: itchysf | Last post by itchysf, Today
Hi Every one, I have a problem with a DB I'm building, I've got it all finisherd except the front form. What I'm trying to do is populate a grid of 9... more »
attachment
Area Chart without individual data points
[image]Post Reply? | Posted by: fnzeee | Last post by fnzeee, Today
I have a table of data with the following fields: Resource Name 1, Start Date 1, End Date 1, % Allocated 1, Resource Name 2, Start Date 2, End Date... more »
Formulate Index Value
[image]123 Replies | Posted by: MNNovice | Last post by NeoPa, Today
I have developed a database for my CD collections. I am trying to develop serial number of each CD which will populate based on data entered in a... more »
Access 2003 defaults
[image]4 Replies | Posted by: robert382 | Last post by robert382, Today
Hi Does anyone know how to chage the following default setting in Access 2003? Under "Find and Replace" the default setting is "Whole Field", I... more »
Leban's Report to PDF question
[image]16 Replies | Posted by: JessicaZ | Last post by JessicaZ, Today
Hi everyone! I'm new here and have a question regarding Leban's report to pdf tool. I am working on a database where we are using this code to send... more »
Calculated Column in Subform Problem
[image]4 Replies | Posted by: mshmyob | Last post by mshmyob, Yesterday
Going to post this real fast since I have to go out, so I hope I get all the pertenent info in the message. I have a subform and the results are... more »
help with filtering results in a search form
[image]19 Replies | Posted by: didacticone | Last post by didacticone, Yesterday
I created a search form that works well except when i am searching for a record that has multiple entries in the corresponding table. i would to... more »
date-limited query hides previously-selected items in combo box
[image]8 Replies | Posted by: WyvsEyeView | Last post by NeoPa, Yesterday
I have a datasheet subform on which users select a topic from a combo box populated by a query, qryListTopicsCbo. This query limits the list to only... more »
Auto Syncing Replicas
[image]11 Replies | Posted by: jzalar | Last post by NeoPa, Yesterday
We are lucky and get to run an 11 year old version of Access (97). I have set up a master with 5 replicas. These are located on various network... more »
Count and percentage of specific records
[image]23 Replies | Posted by: plaguna | Last post by ADezii, Yesterday
This is an example of what I have so far in my Access Report. Internet Source Salesperson... …Appointment Kept AutoTrader ... more »
attachment
Viewing duplicate entry
[image]17 Replies | Posted by: ashenton | Last post by puppydogbuddy, Yesterday
Hi, I have a stock database and have recently solved an issue with duplication. When a user enters a duplicate value in the 'DAMS_Number' field on... more »
Counting rows
[image]Post Reply? | Posted by: anishap | Last post by anishap, Yesterday
Hello, I have a table with the below data: ID Cat Rat Rabbits 001 A B D 002 A C E 003 B A A 004 A E B more »
Combobox - refresh problem?
[image]4 Replies | Posted by: EManning | Last post by EManning, Yesterday
Using A2003 w/ tables linked to SQL Server. All users have their own copy of the mdb. I have a combobox whose rowsource is a query. This query... more »
Basic form Issues
[image]2 Replies | Posted by: Sep410 | Last post by Sep410, Yesterday
Hi all, It may be funny for expert but I am pretty new in Access and I have to develop an application in access2007. Here is the list of funny... more »
UPDATE Syntax not working
[image]2 Replies | Posted by: Constantine AI | Last post by Stewart Ross Inverness, Yesterday
Hi i have this code that Adds data into a Purchase Order Header, then displays the PONumber in a Message Box and finally Updates the PONo within the... more »

Latest Articles: Read & Comment
Top Microsoft Access / VBA Forum Contributors
[ http://bytes.com/adLoader.php?parent=database


You are viewing a mobilized version of this site...
View original page here

Mobilized by Mowser Mowser