Search results

Jeremie - thanks, we have been successful breaking it apart. I just want to understand why we would need to if we haven't hit any ceilings... Mission2 - thanks for the reply. We have not moved old objects into a new database and then compacted and repaired. But we have created a brand new...

We are experiencing failures writing to Access tables when we go over 100 MB. We're using a third party application (SAS) to write directly to Access. We are positive that we have available disk space (we have 10 GB available). We created a copy of the database and removed unnecessary...

Doc - that sounde pretty straightforward. Not sure exactly how to implement. FoFa - I like your idea, but I'm not being paid for this job. If I introduce that capability, It may end up creating more work that I'm not being compensated for. Before you judge, it's for my Dad. He asked for...

My database is for flower arrangements. So I have a master record for the arrangement and related records for all of the pieces that go into an arrangement. (Thanks to Old_Soft_Boss for his assistance with this project). The client would like to be able to bring up an arrangement and modify...

sorry! if you're naturally lazy, you just can't help yourself! :)

Actually, the splitter wizard is much easier. It's one click, then choose the location for the backend.

Private Function GetSheets() Dim i As Integer Dim strSheet(3) As String strSheet(1) = "This Sheet!" strSheet(2) = "That Sheet!" strSheet(3) = "Other Sheet!" For i = 1 To 3 DoCmd.TransferSpreadsheet acImport, , "Table" & i, "y:\testing2.xls", True, strSheet(i) Next i End Function

I have to agree with Pat - now that I have more experience. I'm not in the IT group, but I think it's safe to say that most "Corporate" IT groups use the same model as described by Pat. Here's the dilemma: The non-IT folks need a cost effective solution for many "little" things (i.e. database...

Here's another twist. Forms are not necessary. By that I mean that you can create a set of tables, ADD, EDIT, and DELETE rows to your hearts content. Create queries like there's no tomorrow. Import and export with other Office and ODBC products. And basically have great success. Assuming...

Actually, I just want the form - no data. This is an unbound form and I don't want to have to rebuild it in excel!

I'm wondering if it's possible to export an access form into an excel userform?

Thank you Oldsoftboss... I can use this.

normalization? Maybe my table design approach is flawed? My thought was this: Have a table of unique parts to serve as the lookup table for the arrangement details. Parts have a unique Id and can be maintained separately from the other tables as necessary. Now, I guess I'm breaking the...

Ok folks, I've had enough with experimentation. And as much as I've stared at the code in the NorthWind sample db - I still can't get it right. Parts table Fields: PartId (autonumber - no dupes) PartName (text) Price (currency) Unit (text) Master table and associated form called -...

Perfect Rob! I just didn't realize I could type the UNC directly in the file field of the dialog box! Now I can distribute this thing on time. Thanks

I can't remember how to change the linked tables on a network share from drive letter to UNC for distribution. I remember being able to find a way to edit the links in 97. Either that or I'm a complete idiot - which is more likely the case. Thanks in Advance

I should be using the .To = strecipients instead of recipients.add. my bad

Basically, recipients.add works fine with 1 email account (name@domain.com). As soon as I add another name to the string, separated by either a comma or a semi-colon, I get an undeliverable message. (name1@domain.com; name2@domain.com). Here's my code: (note - the function uses strecipient...