Recent content by shwin

Hi All! I currently have a database where I can browse for a file and attach it to a list box. My problem is that the customer wants the file to open as read-only so and they can save as another name. Is there a way to open up a file as save as? Thanks for your help everyone!

Hi everyone, I have a problem which I haven't been able to correct with the help of the forums. I have browse button for the user to select a file. The file will be displayed as a hyperlink. I would like to create a button that adds this file hyperlink to a list box. I think I should use an...

Hi thefrstgatsby , I am trying to do the same thing as you are. I have been searching around and have found two sample databases which are really good. I am trying to put a browse button which would allow users to select their document. When they select their document/file, it would put a...

Thanks for the help AccessGuruCarl! If you can provide a code sample it would be great! Thanks!

Hi guys, I have a very similar question to TomTiddle's. My problem is that the tables are linked to a server and I don't want people recieving emails from everyone who opens the application. I was thinking that when the email is sent it would take note of it and not send it again. My idea...

Hi Everyone, I am trying to automate email in my Access 2000 and so far it is working! It currently sends out an email open being opened to a set number of users specified by a query. My problem however, is that we are on a network where there are multiple users accessing this file all...

-------------------------------------------------------------------------------- Hi Everyone, I am not sure what the best forum for this would be but I have some questions regarding automatic emailing through Access 2000. I actually got it working! I currently have it set up such that it will...

Hi All! I have a form which has a filter by form feature. The navigational bar at the botton of the form does display how many records I have and also how many records have been filtered, but I would like to display this number on the top of the form. In other words, I would like to record how...

Hi Guys, I am trying to put together a Filter by Form button on my form and I do not want to use the function built into Access. I found this example of a custom filter by form and after reading the "read me" and reviewing the code, it seems that I should be able to use this in my application...

Hey everyone! I have a question regarding calendars. I have a calendar from the ActiveX controls on a form. It is attached to a combo box so that when you click on the combo box the calendar pops up and you can input a date. Here is the site I used to do this...

Hi Guys! I have been reading the postings on the forum but I have not been able to get what I need from them. Maybe one of you guys can help me out. I have a form with 3 fields: Month, Year, and Hours. I would like to calculate the Total Hours, YTD Hours, and Quarter-to-Date hours for...

Hi Everyone! Is there anyway to disable the close button on the top of the Application on the Title Bar? I want to prevent users from closing the database so I want to disable the "x" on the title bar. Thanks for your advice!

Hi Everyone, I am new to Access and am running into a few problems with my database. On my form, I have three date fields (DateAgreed, DateRevised, DateClosed). The dates are entered using the pop-up calendar feature. My question is regarding how to lock this data once it is selected and...

Hey guys, I have a general question about Access. When the user creates a new record, is there a back button that will undo this new record. To elaborate, the user has not entered any data into this new record and clicking on the "Go To Previous" button has no effect. Any help about Undo-ing a...

Hey everyone, I would like to insert the year and month in the following format: YY-MM I am new to access and have no idea how to go about this. Any ideas would be appreciated. Thanks for your help!