Recent content by worldcert

Thanks guys I will investigate all your points and try and come up with a solution.

Unfortunately the certificates dont have a set period of time. I need to compare the expiry date to the actual date. I took this code.. UPDATE TBL_Certificate SET TBL_Certificate.Status = "Expired" WHERE (((TBL_Certificate.DateCertificateExpires)=Date())); and added it to the Click Event so...

Hi Guys and Girls I am struggling to find a solution that I am sure is quite simple for someone more experienced than me with Microsoft Access. I issue certificates and have a certificate table in Access. I have fields called "DateCertificateExpires" and "Status". At the moment I have to...

Hello I have a form with multiple tabs at the top. Each tab opens another area with fields all stored on the same table. I added a find button and it generally works but this following error message sometimes pops up. "The microsoft jet database engine stopped the process because you and...

Hi Rabbie Thanks for your reply. I half fixed the problem. The Name of the button was different from that stated in the code. I changed the name and button now works. HOWEVER here is my process .. I open the form and cannot edit the record. GOOD I click the button and it allows me to edit the...

Hello, I have a problem that im struggling to fix. I have a database and the form is set to not allow editing on the clients page. I would like a button so I could click to enable / disable editing. For example when I open the form you cannot edit the record. I click the button and it now...

Hello, I asked a similar question is a different area but no one knew the answer. I hope some one here can help. I have an Access Database and I extract data from an Access Form to a Word Template using bookmarks. Its invoice data I am trying to extract and print so the data is numbers. On...

Hi Richie P To extract my data I created a command button and on clicking it there is an event procedure. Here is the code. Private Sub print_Click() On Error GoTo Err_print_Click Dim objword As Word.Application Set objword = CreateObject("Word.Application") With objword...

Hello, I am having a problem with access/word. I have a database with an invoice page. When I print an invoice a word template opens and the data gets imported against bookmarks in Word. However the problem is the data in access will be formated like this 500.00 and in Word like this 500 If...

Hi ghudson, I had a look at your thread and link about browsing. Im not that good with access coding and it all looked a bit complicated so I went with the simple code. When I get a bit more time I will have another try. Cheers

Thanks for all the replys. I have kind of fixed my problem. I went to the form, entered design view, created a command button, event procedure and entered the code On Error GoTo Err_cmdExplore_Click Dim stAppName As String stAppName = "C:\Windows\explorer.exe Z:\WCS\Clients\" Call...

Basically if a client ID is 9500 on Access then I will have a folder on the computer like c:\WCS\Clients\9500 I would like a link on the Access Form for client 9500 to either open a file in the client folder or open the folder to browse all the files. Cheers

Hi Di Hi I am new to Microsoft Access and have a little problem. I have searched the forum and nearly found the fix but I didnt quite understand what to do, so im creating a new thread. I have a Access Database and have a client page that stores all the information about that client. We...