Search results

Can you post an example?

Hello, More information is needed, how are you populating the listbox, SQL or values? Whether there is anything unique to hide by, i,e, if people there could be 2 John's, but each of them will have an Employee_ID say, of 1 and 2, so you can remove by the IDs Please supply more info and...

Set the outcome of the null status date to be a number, 0?

Use a SQL Join

1st Off. strsql = "SELECT TblRef.BarcodeRef FROM TblRef WHERE ((BarcodeRef Like '" & strText & "*'))" think you need to clear the dropdown 1st and set to value list if not already.

Have you tried passing all the database details in your connection string? So you have something like Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; Persist Security Info=False; and then you can use the execute statement on this?

When you are modifying for SQL you will need to put it like this Where FIELD like "*WHATEVERTHEYWANT*" You can pull this out, by using instr and instrrev to search for the "'s and then mid to get the text inbetween them.

you need to change the .body to be htmlbody or bodyhtml, in your email sub

or have your first query an append query, and use a dummy table to hold the params then you can refer to them.

You will need to send the email in HTML format, and add a hyperlink as the normal HTML way.

DoCmd.Save acForm, "tmpQueryDes" Microsoft Office Access cannot complete this operation. You must stop the code and try again. DoCmd.Close acForm, "tmpQueryDes", acSaveYes The Close action was canceled. I am running the modifications from a class, i only want to save the changes i've made to...

Hi, I am trying to open a form in design mode and add controls, this i have done. I am doing this all in a class, and am having trouble saving the modified form. I have tried using the following, both produce errors DoCmd.Save acForm, "tmpQueryDes" DoCmd.Close acForm, "tmpQueryDes"...

Hi, I am trying to sink the events of 42 command buttons on one form. I have created the class clsCustomCommandButton Option Compare Database Private WithEvents mCommandButton As CommandButton Public Property Set CommandButon(ByVal oCommandButton As CommandButton) Set mCommandButton =...

would be SELECT * from tblTest FROM tblTest WHERE cstr(Format(Left([DATE_FIELD],10),"yyyy-mm-dd))= "2012-11-21"

Hi Ken, Did you get any joy with my note?

SELECT tblLabourHours2.Trans_Date, tblLabourHours2.Cost_code, Sum(tblLabourHours2.Hours) AS SumOfHours FROM tblLabourHours2 GROUP BY tblLabourHours2.Trans_Date, tblLabourHours2.Cost_code;

Hi, Its not that tricky. You need to use subqueries and DLOOKUP so you will have the following, using Josephine. I have called your schedule table tbl_Schedule. iif(DLOOKUP([Morning],[tbl_Schedule],"[First Name]='Josephine'")=1,(Select [Time] from [tbl_Diary_Time] where...

SELECT tblTest.EndDate, Format(Left([enddate],10),"yyyy-mm-dd") AS Expr1, Format(Left([enddate],10),"yyyymmdd") AS Expr2 FROM tblTest;

Hi You will need to add two columns, not shown, to your query. These will be something like Format(DATE,"yyyy-mm-dd") and have your criteria in there OR Like "*" & Format(DATE,"yyyy-mm-dd") & "*" , just using the date output as is 2012-09-22T12:38:00+00:00 so either criteria will...

HiI have a text box, bound to a memo, in a sub form, in my main form. However, when the user gets to the bottom of the text contained, to add further details, the textbox scrolls up to the top, when the first key is pressed.Is there a way to stop this?Thanks.