Search results

Thanks for your message. I have done as you said. Made a SUM(HoursWorked) Textbox in the footer of the subform. i have tested this (and apart from the format) it is giving an output into the textbox. I have also created a second textbox on the main form, and in the control source, set that to...

I am trying to sum up the hours worked field in my subform, I have tried different DSum functions but I can't get it to work. Attached is an image of the form I am trying to sum and place into the text box. This is what I have tried: =DSum([HoursRecorded],"tblTimesheet",[qryTimesheetByClient...

Private Sub Command363_Click() DoCmd.RunCommand acCmdAddFromOutlook End Sub I have the above code attached to a button and I am receiving an error 'The Command or Action isn't available right now' This is the same code from a template (and it works on there) so I clearly have done...

You made that sound so easy :-) Resolved, thanks for your help!!

I have tried both early & late binding. There must be something wrong here somewhere I am convinced the code is correct: Option Explicit Sub EmailClient() Dim objOutlook As Object Dim objOutlookMsg As Object Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As...

I have allocated the foillowing Sub to a Button Clink: Private Sub cmdGo_Click() Dim SQL_Text As String SQL_Text = "SELECT tblClient.*, tblClient.ClientName FROM tblClient WHERE (((tblClient.ClientName)=Carl));" DoCmd.RunSQL SQL_Text, False Me.Requery End Sub I keep getting the...

I have seen how to go about this now and it makes sense using a split form with a datasheet at the bottom. One more query though. I keep getting a white band across the top of the form divider line (see attached). I have tried everything to try to get rid of this. I know it is possible...

Ok thanks I will give this a whirl shortly and repost if I am still struggling. Thanks for your help.

Wow ok, i think I'll need sometime to digest this and give it another try, there is so much functionality in access i think it can be rather daunting maybe that's why most people just use spreadsheets. Thanks for the headsup re lookup fields as well I will replace these with the necessary table...

Thanks. Attached is my DB. It really is just a practice thing with no sensitive information in at all. I want to make the form view of frmClientMaintain the same sort of datasheet view in the body as the attached image in the previoyus post (TemplateForm view). I need to know what I am doing...

I need to know how to add a new record to my clients table from the AddClient form. I already have the MainClientList form and the Button to open the Add Client form. But when the AddClient form opens how do I ensue the fields are empty for the user to populate but at the same time have Access...

Thanks jzwp22, however I just checked this and it is already set to 'Singe Form' ?

I am hopeless at this!! I am trying to get my head around why my form is not the same as the one from a template. I am just trying to copy it to practice how Access works. The template one shows as a datasheet, but the layout view looks just like mine. See attached images. Maybe there is...

I would like to be able to click a button which opens up another form where the user can insert a new client. Within that new form all the field should be empty except for the ID field which would be autofilled by Access. I hope that makes more sense.

I have a form on which I have placed a Button which opens my AddClient Form. However, I am not sure how I link this AddClient form data source to my client table as at the moment with empty fields but the ID field of the client automatically generated. The Contact ID field int he table is an...

I have only just got around to this, thanks for your help I have managed to sort it :-)

I want to produce a conditional query. So for example, I have two dates, a baseline date and a reforecast date. I want to query a table and select only the later so ie if ReforecastDate> BaselineDate then return just the ReforecastDate otherwise return the BaselineDate. I know how to select...

Nigel you say it like it is so easy I'm envious ;-) Your fix worked and i appreciate your help on that (you wouldn't beleive how long I have spent trying...) Cheers buddy.

Thanks for your email tried that: SELECT TTask.TaskID, TTask.TaskDescription, TTask.TaskPhase, TTask.CriticalPath, TTaskAccountability.Who AS AssignedTo, TTask.LeadIn AS LeadInWeeks, TTask.WorkPackage FROM TTaskAccountability INNER JOIN TTask ON TTaskAccountability.AccountabilityID =...

I have two queries below, they are exactly the same except that I am getting a data Type expression Error on the second one. Simply, in the 'Critical Task' field the value is written in text either "TRUE" or "FALSE". I have starred at this for sometime but I just can't get it to work. All the...