Search results

A way to do this without complicted VB code would be the following 1.change your sub form to another regular form and have it stand on it's own rather than being a sub form embedded in the main form 2.build a query on whatever table holds the records to be populated in the form once the invoice...

Even after downloading the Jet Update, when I set the macro security to Low, it continually defaults back to Medium. Any ideas here? Thanks in advance for any help. DG in KC

reset ODBC connection You may have to set the System DSN using a different Oracle Driver. To do this: 1. Go to Start/Settings/Control Panel/Administrative Tools/Data Sources (ODBC) 2. Click on the System DSN tab 3. Make note of the System Data Source name 4. Remove the data source 5. Add...

Attach Current dB object I think this is a simple one....I've added this code to my dB to get around that ever-frustrating "An application is trying to send..." error. It works great! However, I'd like to attach a table to the e-mail rather than an external file. I've tried everything I can...

Hi there. Was wondering if anyone could tell me if it is possible to get rid of the horrible little "X" in the top right hand corner of the Access App? I know how to hide it in a form, but need to hide it on the app itself. This would force end-users to actually use the Close App button...

When you use referential integrity, you tell access that record #1 in Table A must have a related record in Table B. What this does for you is prevents related records from being deleted. For instance, you would not want to have a customer Id in Table A with no Order in Table B. Have you...

That's a problem with the join in the relationship. Go to the relationship tab at the top of dB window. There is an option to "Enforce Referential Integrity" if you uncheck that box, it should help.

Dan- What you have to do is identify what piece of information should be unique for each record. For instance, if I am placing an order for three items, but you don't want duplicate lines for each item, then the item number would be the unique identifier. That would be the field you would...

We are using this process as a quality control check and would need to keep atleast 1-2 weeks worth of work assigned in the dB. There may be need in the subsequent weeks to go back and report off of the data. We'd like to be able to report on work assigned to a person on any given day of the...

Hello all! I am using the CopyObject method in the event procedure of a command button to make a copy of the underlying table. I'd like to be able to date stamp the new Tblname with the current date. Effectively, every day that work is assigned, the assigned case load for that day would be...

Ok, I know that Access can be a little flaky at times, but this one deserves to be put out there! Could someone take a look at this error that I am receiving and tell me what they know? I am building a make tbl query that only has two fields: cakes|countofcakes when I try to run it as a make...

I think I atleast figured out why it won't query correctly. The data is pulled in from a .csv file where the date is 20010814. Because the date is in this format in the table too, it won't sort it correctly. Silly me. I shall try to import with the correct date format and start at square...

This has got to be sooooo simple!!!! I just can't get it figured out. Tbl stores all "requests for service" and "date requested" Turn around time on filling request is 5 business days. I need to query on requested date and bring back only those that were requested 5 days ago or more...

Ok, here we go.... Have a tbl that has multiple line items for one acct. Acct No. 30 day bal 60 day 90 day 457 $2.57 $5.93 $0.00 457 $0.00 $6.23 $10.01 457 $15.17 $5.93 $11.25 457 $0.00 $0.00 $0.00 And here's the...

Here's something else that's cool...if your client doesn't mind typing the date range in twice, you can actually put the following in your report header and display the same date range on the report itself. To do it, place a new text box on the report header, say, under the report name. Delete...

Firstly, thank you both for your help! Pat- The case id is the unique value throughout this db and is an autonumber. So, I tried the first code that you suggested. However, I am having the same results as before, it is calculating, but it is only summing the balances of the first record in...

Ok, here we go. I have an main form that pulls up general case info by case id (unique value) It has a subform that brings all accounts and acct info (from another tbl)related to each id. Each case could have multiple accounts. Each account has a balance. On the main form, I need to be able...

With some help from a colleague, this has worked. Thanks again! You have always been great about responding quickly and with great information. Rock on!

Charity, First of all, thanks so much! I wish I knew more about code so that I could help you to help me...haha With time, right? Anyway, is this kind of search limited to only unique values such as a case id would be? What I am really looking for is a way to conduct a search by any piece...

I have placed the following code on the dbl click of the list box, and it will not pull up the record double clicked. it continues to simply pull the form up in edit mode starting with the first record. Any ideas? Private Sub List0_DblClick(Cancel As Integer) On Error GoTo Err_listbox_Click...