|Microsoft Access Forum||Combo Box Issue by Sue S: I set up a customer table and a vehicle table using the training provided from Work Order class. I want to add new vehicles that fill in the customer combo box and even though I had tested this before and it worked, it is not now. I followed instructions in setting up the Combo Box on a new record in adding the Customer ID in the Default via a more...|
|Microsoft Access Forum||data in a single form to two tables by Les S: Is there a way to set up a form as to when information is entered in a field it populates in two different tables?|
|Microsoft Access Forum||2000ish record in DB by Mohamed Hashem T: Hi all,
I am tring to build a database for an IT vendor where I exported the Partners database ( 2000ish record) I also exported another list of Partners( 450 ish record) purchased the last 4 Qs.
I am trying to link those tables together. As per Access Expert 1 the instructor was adding the Contact ID to the Customer ID manually more...|
|Microsoft Access Forum||OLE Object by Dan C: I have office 356, and when i try to drag and drop a bmp file into the OLE box on a form all i get is an icon no photo. can someone please tell my this does not work the same as is does in the lesson.|
|Microsoft Access Forum||Microsoft Access Forum by Joseph M: Is there a way to programmatically assign a table name to a table created by a make table query? I would like to be able to append a date to the name of the table for easy reference. I thought I heard Ric say there is a way of doing that and he would include it in a future class. Has he done that yet?|
|Microsoft Access Forum||Combo Box by Mohammad H: my database is a bit different than the example you shown. I have some companies who are my clients and there are some employees working in different positions within these companies(clients). One client can have many employees whom I want to create a contact history. now I created two tables one for companies and the other for their employees. How to create a more...|
|Microsoft Access Forum||Drag and drop the edge of a window by Eric M: Since my office computers were updated I have noticed it is extremely hard to resize anything in access.
Move you mouse to the edge of a form click and drag to make it wider?
Seems simple enough.
BUT... since the update it is almost impossible to get the pointer on the exact spot where the mouse pointer more...|
|Microsoft Access Forum||Up and Down Command button Picture by Eric M: I would like a command button that when clicked, the arrow changes direction up and down. and then based on the direction, it does something.
Currently, I make this work by placing two buttons directly on top of each other so it appears as the same button and has the code.
Private Sub Qa14SortDB_Click()
|Microsoft Access Forum||Many to Many relationship by JR: Hi.
This one is a hard nut;
I want to fill out a Workshop order.
I use a WorkOrderTable and a EmployeeTable
This order will be received by one empoyee, it will be designated to one employee, and it will be signed out by one employee when the workorder is done.
(The "one" employee can be different persons from the more...|
|Microsoft Access Forum||Email Seminar Send Email Without Outlook No L by John M: I built the BulkEmailF and it has worked perfectly until recently. I now receive a run-time error message as soon as the first email attempts to send:
Run-time error 2147220975 (80040211)
The transport error code was 0x80040217. The server response was not available
I have more...|
|Microsoft Access Forum||Access Calendar Seminar by John D: In the sub s1 = "Date" & X
S2 = "Day" & X
x being the counter|
|Microsoft Access Forum||Monthly Calendar Seminar by John D: Just finished videos for 2nd time and completed Monthly Calendar. All worked well except greying out boxes on Monthly Report. Code is same as video and is in detail section of report. Using Access 2016, Win 10. Can Rick take a look? Thanks John|
|Microsoft Access Forum||Long refresh when VBA editor is active by Jan H: When I use the database as a user the refresh time is resonable and the refresh does not happen so often. However, as soon as I open the VBA editor the refresh time is long and VERY often. If I close the VBA editor, the bad behaviour continues.
Is there something I can do?|
|Microsoft Access Forum||Database templates by jannette j: I want to create like 3 database templates so my clients can choose what database format they would like. one with VBA code and all. I just do not know how to get started. I am trying to move more users in the plant where i work towards Microsoft Access and not so much to Excel. I thought if i can wshow them how great access is they would more...|
|Microsoft Access Forum||Month to date sum by Wenyuan C: Hi,
Is there any way to sum month to date value?
|Microsoft Access Forum||Microsoft Access Forum by Les S: I am presently on Access Expert 4 part 3 Extended Customer forms. When I enter the address for a picture in the picture text field I keep getting Invalid control Property:Control Source and Not such field in the field list. I copied and pasted the path to the folder so I know that is correct. Any ideas on why this won't work?|
|Microsoft Access Forum||Copy and paste by Kalyana K: Yes you can copy paste debase normal copy paste. if you need create folder and copy|
|Microsoft Access Forum||Microsoft Access More Users by Kalyana K: You can learn lots of things. Crate table, forms, Query, Subform, Report, Analysising etx,.|
|Microsoft Access Forum||Printing single report by Stacy H: Hello, is there a way to only print a single report (using a primary key) instead of having to print all reports? Other than setting pages on the print options, I would like to open a report specific to the primary key and print it.|
|Microsoft Access Forum||Microsoft Access Forum by Kenneth M: I'm not sure if you covered this or not, can Excel formulas be used in Access?? . For example: I have a formula of =IF('TrainingDate'="",180-TODAY()-'RegistrationDate',""). My students check into a course and are required to complete the course within 180 days. What I would like Access to do is to calculate the days between the two more...|