Search results

I got it down to 96kb in size so here it goes!!!!! :)

Yes I have, only two records in the db. There were some preformatted backgrounds that I took out and so now the zip file size is 109! I can't believe I still need to delete more stuff so I am working on it. Hopefully I can get it down to 100 today so I can send it out. Thanks for staying with...

I figured out what I was doing wrong on sending the attachment but i will still have to work on it. I needed to send it as a zip file, however when i did that then it said it was to big a size, they only take 100 and my file size after zipping it is 240 (orig file size was 950). I have...

attachment OK i tried to send an access 2003 attachment and i dont see it does anyone know how to include an attachment with their post?

This is an old problem I have had with several db but never got a fix for it but I really need this to work now! I have read many threads on the matter and have tried several fixes but I just can not get it to work so I am attaching a sample file in hopes that someone out there can help me!! I...

Thanks guys, i think i will go with RichO idea cause i think with a snapshot it is not updateable. I have two groups; one will be adding records while the other is viewing only. They don't want to set up user level security so i built two forms; one with regular form properties and the other...

I have a form that has a combo box to lookup a record in a form, works fine until i changed the form's properties to "no" on the allow edit, deletions, additions. I want a form that basicly is read-only but i want the user to be able to use the combo box to look up an existing record. Anyone...

thanks soo much, this has been bugging me for a long time

Can anyone tell me why access puts the primary key field in the index list twice for the same table? For example i have a primary key called CustID, when i go into design view and click on the index button on the toolbar, i see it listed twice, once as primary key and then again as its own...

I have linked my Outlook calendar folder to my access database and can see all my appts. When i add a new appointment in my access database, it does not update my Outlook calendar. Is it possible to do this without knowing alot of code? Thanks for any help :)

OK Pat, i thought i had posted it in the SQL forum

I can see it in Access front end not in SQL server backend, i am using the Enterprise Manager to view my queries, how are you able to see this in SQL backend? thanks for your help

Can you tell me how to do this in MS project frontend and SQL backend?

turn off confirmation in SQL server Hello Pat, I have a similar problem but mine is with msproject frontend and SQL backend. How can i turn off the confirmations? In Access i could turn it off in the tools, option but with MSProject it is not available. My guess is that i will have to write...

customerID is a text field but i tried your suggestion anyway and it returned me this #Error in the fields. :(

I have a groupby query that i use to group by visitID and then max the Visit date so that i can have the last visit date for each customer. I have a form that list customer information and has a DLookup field that should lookup the last visit date for each customerid. I am getting null values...

Is there a way to clear the value in a option group after you have saved the record? For an example, a y/n field lets you select it and then select it again to change or clear the value.

I have a Main form Called "Company" Subform called "ContractInfo" Subform within subform ContractInfo called "ContractDetailsdatasheet" and field name "CourseID" How do i reference this field? I tried several ways this is one of them...

OK i figured something out that works but i would like to know how to do this by creating a public function and then call that function instead of writing the code below on each controls' AfterUpdate Event. Private Sub Markers_AfterUpdate() If [Registration Forms] And [InstructorPymt] And...

I have a form that uses subdatasheets also and it was working fine until today. When i open the form the + is gone and so i can not view the subdatasheet. I know i have several records but do not know why it worked yesterday and doesn't today. Has this happen to you? Do you know of a fix...