Search results

Hi, I am trying to sum time in minutes and display the result as hh:mm but getting all sorts of problems as the minutes always seem to be related to a date rather than just numbers. Here is the sort of thing I want: Time Day 00:55 Mon 00:25 Tue 01:20 Wed 00:30 Thur 00:30 Fri...

Hi, My report has started printing the details twice:eek: I have been using the report for quite a while and never had this problem before, although I have been modifying things quite a lot recently. I can't see anything that might cause this or even think of how to do it. Any ideas...

Hi there, Chatting with someone who used Excel a lot, I mentiond the method I use in Access to concatenate things without spaces when an item is null. For example: Expr1: [FName] & " " & ([MName]+" ") & [LName] The bracketed middle part of the expression will not produce anything if there is...

Hi there, I posted a question about this a while ago and got no response. The only thing I found on a search was a dead link to a solution, so I hope you will forgive me for posting again. I email reports from a button on my form. All works fine but the attachment to the email has the caption...

A colleague passed on the advice that you should always stop a flash drive before removing it. I have never done this, indeed until he showed me how, I didn't know how to do it r even that it could be done. It makes sense not to remove the flash drive when reading or writng to/from it as you...

When using sendobject to email a report, can I send a carriage return in the message somehow? "chr(13)" doesn't work. The snapshot file attached to the email takes the report caption property to generate the filename "caption.snp". I have been able to set the caption in the on open property...

Lots and lots of posts on this subject so it is something that obviously gives lots of trouble to newbies such as myself. The code below works fine if the control is not null but gives Error 94 - invalid use of null when the control is null. I have gone around in circles with this - what am I...

Hi, The code shown below generates the reprot with no filtering. I want to have the report for the current record only based on the ProjectID. StrCriterion = "[ProjectID]=" & Me![ProjectId] DoCmd.SendObject acReport, stDocName, , , , , Subjecttxt, Messagetxt, , StrCriterion...

My report has a number of subreports. If all the subreports have data, the detail section of the report will break onto the next page. So far so good. My problem is that the subreport at the bottom of the first page is breaking rather than printing all together on the next page. Is there any...

Subform Blues - Data Entry setting itself to 'No' & Requerying 1 subform from another 2 Subform problems I have a data entry subform that is only supposed to show an empty record ready to be populated, and a display records subform that is supposed to show all the records. The subforms are...

My children are 2 and 3 years old. Pretty soon (when we return to Perth Australia in the new year) I would like to get them a pet dog. The children will be too small to take any of the responsibility of looking after/exercising the dog so it will all be down to me and my lovely wife. That being...

I want to use SQL to populate a variable that is used elsewhere in my code. none of the various methods I have tried work so I was wondering if this is possible in the first place and if it is, what is the syntax/structure of the code? Dim DeptOrder As String DeptOrder.DoCmd.RunSQL SQLText &...

I have a combobox that may be used a number of times. It is populated by a query in VBA using rowsource = SQLText & WClause etc which sorts it in a particular fashion. Currently, when a user clicks the drop down list, the last selected record is at the top of the list and if the user wants to...

I have an SQL query that filters a subform based on the selected item in an option frame that runs on the after update event of the option frame. Forms!fsubPrjPersonnel.RecordSource = SQLText & WClauseWhen I try this out, I get the following error message: I then ran the following snippet and...

I know how to do this with a combo box. After defining the SQLtext and WClause something like: with me.cbocombobox ____.rowsource = SQLtext & Wclause ____.requery end with How do I (can I?) use the SQL in VBA to populate a text box in a similar manner? I have tried various versions of...

I want to filter a form based on the many side of a 1 to many relationship to the records on the form The form shows projects which can be associated with more than one asset. There is a junction table to hold the asset assignments with a many to 1 relationship to the project details table...

Can I use SQL to populate a text box in a report? The source table has 1 field for employees assigned to projects, and I want the report to show employees for each project broken down into the sections they work in. The desired result would look something like this: Project XXXXXX...

This sounds like a cascading combo box issue but it isn't quite. I filter my form using 2 unbound combo boxes which can be used in any order, both of which define text strings using case select. These strings are concatenated into a filter text and applied by a routine called in the after...

I have a hidden combo box that is populated by SQL text in VBA when the user selects an option from a frame select. It is then displayed in drop down mode for the user to select a project. The form then synchronizes to the selection and the combo box is hidden again. At least that is how it is...

I am trying to improve the performance (loading time) of my main form. The big tip seems to be use SQL in VBA to populate subforms and comboboxes when needed, rather than when the main form loads. I have a combobox configured for 2 columns, bound column = 1 and column widths set at 2cm each...