Search results

dcx693, Thanks for those links. I thought I found what I was looking for with the second one. Below is taken directly from the site "A parameter that can accept an input from the user, but that will return all records if no input is made is written..." [type prompt here] Or Like [repeat...

Hi, I have a form which prompts the user for information and runs a query based on this information. Sometimes the user will be leaving some of the fields on the form blank but I still want my query to return all the records so I have the following in the criteria field of my query Like...

Hi, I have Access calling up an new outlook message. However I need to know whether the user decides to send this message or not. I know mailItem has a .sent property but I cannot get this to work. Here's a little simplified excerpt from my code. oEmail.Subject = "Some subject" oEmail.Body...

Hi, I have some comboboxes with DLookup functions in them. The DLookups use values from other comboboxes on the form. However sometimes these are not filled in and as a result the combobox containing the DLookup comes up with "#Name?" or some error. Is there anyway I can set this to null and...

This is going to sound a little sad but I can't change the colour of the tab control and that's why I'm not using it in this instance! I figured out a bit of a botch of a solution anyways. My problem was with the subform recieving focus so before I invoke the GoToPage command I simply use...

Hi, I have a form which has three distinct sections on it. I have used the page break control to break the form into a number of sections. When I view the form and use the PG UP and PG DOWN buttons the form jumps between sections. However if I place a subform into these sections the page...

Pat, Thanks a million, that's the answer. I had to re-jig the query slightly to make it work but it does work :-) "INSERT INTO PREV_ISSUED ( [Stock Item No], [Start Date],[End Date], Place, Team, Person ) SELECT " & getStockItemNo() & ", " & Format("getStartDate()", "dd/mm/yyyy") & ", " &...

Lads, Thanks for the advice but I'm still in trouble. It does seem to be the SQL alright. The getStartDate() function is returning it in the correct format. I know this because I simply have a message box popping up displaying the date before running the sql. Ths msgbox is simply for...

Hi, I have an SQL query which is appending a record onto a table. Part of this append query is to insert a date which is returned from a function into a field in the record. This field has it's format set to "Short Date" and the input mask is "99/99/0000;0;_" Here's the problem: The...

I've tried this and all it seems to do is maximise the opening form/ or the database window if you don't specify a form. This hardly seems right, but that's what's happening? Liam

Thanks, The visible property was exactly it. However now I have another small problem. When it opens how do I get the Microsoft Access Window to maximise. It maximises fine when I open the database seperately. Liam

Hi, I'm trying to use the OpenCurrentDatabase method to open one Access Database from a button in another. I manage to open this second database ( a lock file is generated ) but it will not actually display it in the Access window. What am i doing wrong? Liam

segmentSort and alphaNumericSort are two functions as follows: The data in the "Segment" field is text and has the following format: C12/33 C2/4 C23/5/7R C3/2/1L If I just sort by segment alphabetically the order is as above whereas I apply the segmentSort function to get them in correct...

Hi, I'm trying to use the OrderBy property for a form based on a table, however I can't seem to get it to work. I need to apply some functions to the fileds I am ordering and I think this is where I'm running into problems. The following will not work; 'Segment' and 'Pole No' are the two fields...

Hi, I have a query, well it comprises of a query and two underlying sub qieries if you like and it's takes the form that uses it forever to load. Unfortunately, I'm doing this database for someone else and they HAVE to have this form but I need to get the query to run about 10 times faster...

Hi, I have a report with a page header, footer and detail section. In the detail section I have a subreport and there is another master field in the detail section which links the data in the subreport. For every new value that appears in the master field, Access moves onto a new page which is...

Hi, I have a field in a table which needs to store values such as the following: 1, 16, 20, 20A, 43, 100 Essentially they are numbers but some have a letter attatched to the end. Therefore I set the data type for this field to be text. However I still wanted the values ordered "numerically"...

If you want to do this when you close the form then on the OnClose event for the form put the following: If Me.Dirty Then <<the actions you want to carry out>> End If Me refers to the form and is just shorthand rather then specifying [Forms]![name_of_Form]. Me.Dirty simply means that if...

Thanks for the reply! however I have one more query and it's regarding the criteria for queries question. I tried to use this for a date field using Between...And. Unfortunately I couldn't get it to work. However I think Access did recognise what I was trying to do because after I saved the...

Hi, I have two problems with my reports. The first one is pretty serious. For every page that prints out, another blank page prints out also, I cannot seem to fix this. What am I doing wrong? This happens pretty much all the time. Secondly, is there a way that I can print a report "backwards"...