Search results

Thanks, I'll give it a go!

Hi Guys. I have need on my database to export some information into an Excel template to e-mail to another department for them to do some work on. It needs to be Excel so they can upload the information onto the companies system. I can export to excel, but can you export to an existing excel...

yeah I can do that. The thing that I'm having problem with is that if someone goes back into the same record on that form, I don't want it to create a new record, I want it to open the original record.

Hi, Yes, kind of. If the record exists then open the form and view the record. If the record doesn't exist, open the form and run the following; Set rsSubba4 = CurrentDb.OpenRecordset("tbl_over", dbOpenDynaset) With rsSubba4 .AddNew ![Subba3] = SBA ![Blanket...

Hi Guys, I have a form that I want to open, but there are 2 conditions. 1. If a record with the same record in the field Subba exists, then open that record. 2. If the record doesn't exist, open the form and auto populate the records with e record set. I can do all of this, but stuck on the...

Thanks Minty, That Syntax change and a change from .Add to .Edit has fixed it right up.

Hi Guys, Can someone explain the workings of .FindFirst? I'll admit I've been using the .FindFirst that someone helped me with so I dont actually get the workings. So i now have a new record set that I want to update, but I need to match the record before going forward. I have used...

Hi Minty, I'm in the process of swapping over to calculated fields. I'm going half and half. I'm using your DateAdd as suggested, but for clarity I also want to add a field that works out the Date Difference when run. This will update every time the query is run (every time the form is...

Hi Minty, I understand completely what your saying. However I have found that I need to save this information. Currently I have it so that whenever the record is looked at individually on the form, this field is automatically updated on load. The problem is I now need to find all instances...

Thanks Arnel

Hi Guys, I have a table that has a field in it which is a "months remaining" field. This is calcuated by doing a date diff between today and the end date field on the record. I wont paste the whole code, as i'm sure you know how to do it. What I want to be able to do though is have a refresh...

Thanks Minty

Hi Guys, I'm missing something here. Can you take a look at my DLookup and see if you can spot why its erroring? Error is Runtime 2471 DLookup("E-mail", "Tbl_User", "[login]=" & "'" & fOSUserName & "'")

Thanks Ranman

Hi, I have the following query that I'm testing out. It should return only 1 record. However it is returning the same record about 5 times. How do i make it so that it only returns it once? SELECT Tbl_ShikomiRegister.[Blanket Agreement Number], Tbl_ShikomiRegister.[Account Number]...

Thanks Bob and Gas Man, I keep forgetting the control source for the form!

Hi Guys, I'm setting up a database at the minute and I have created a table (Tbl_ShikomiRegister) and a Form (Frm_ShikomiregisterINT). I removed a couple of fields from the table that were not on the form as I decided that they were most suited to being on a different table. The only problem...

Thanks, I knew i was missing something!

Hi, I'm trying to get my database to send a notification if the area assigned to meets a criteria. Other departments don't need an e-mail. It doesn't seem to be working though. Can someone take a look? Public Sub SendLotusNotesMail(strMailTitle As String, strLotusNotesUserID As String...

Hi, Just trying to find the best way to do this. Ideally i'd like an input box on clicking the open link. can you use a record set to populate the unbound text box or do I need to have this as a box a user entry box?