Search results

Current date less 7 days = DateAdd("D",-7,date()) but I do not understand your request. Date received is a table date that differs for each record, is it not?

On the Form...Load Event Me.CommandButton.Visible = False On the After Update Event of the field that turns on the button. If Me.Field = True then Me.CommandButton.Visible = True Else Me.CommandButton.Visible = False End If

1) The Batch Medicine Popup Shrinks when the button is Launched. Popups can be such a pain. If you need help with this let me know. 2) The list of animals is populated from a query. To be able to select and apply the appropriate medicine to multiple selections, you will require a Contimuous...

It all depends on the format of Date Received. If it is stored as a date, then make Date ... Date(). If it is stored as text length 10, like I store dates that I will have in SQL where statements (dates are a nightmare to retrieve in date format since the date no matter how it is displayed is...

http://www.functionx.com/vbaccess/ is recommended by Microsoft. I haven't used them, I learned by doing it, but I am told they are pretty good.

Ruth, How advanced a course? In most cases, the KISS rule is the best way to program (Keep It Simple Stupid). Do you mean VB or one of the data access components (DAO/ADO/SQL Server's T-SQL)? Bob

Your Welcome .... and welcome to the Forums!

Before the closing bracket just add & "' AND [ArrivedDate] > #" & dte???DaysAgo & "#" & "' AND [ArrivedDate] < #" & dteSevenDaysAgo & "#" Use help for the date function to set dte???DaysAgo and dteSevenDaysAgo

ok, thought so, Try Iif(IsNull([tbl_lead_worker]![Role]) = True,Iif(IsNull([tbl_initial_worker]![Role]) = True," ",[tbl_initial_worker]![Role]),[tbl_lead_worker]![Role]) I hope the format is correct....haven't done this in a while, and it is off the top of my head....will check it out in a few...

Is this part of a select, an expression builder or vb code?

Do you want working code, or do you have time to work on it? When an item is removed, it is first removed (deleted from the table), then the user must perform the renumber specifying the number removed, when asked. The procedure then renumbers strating from that number (Eg: deleted #3, click...

In regards to doing this in a loop, here is and example: Dim intCnt As Integer Dim strMsg As String Dim strConvert As String Dim bolErrFound as Boolean strCovert = "one, two, three, four, five, six, etc" bolErrFound = False intCnt = 1 Do Until intCnt > 20 If Me("Tickbox" & intCnt) = 0 Then...

The settings table is a table I create. This table contains application settings, some pre-loaded and some prompted at first use. The pre-loaded include version numbers of the distributed package, version of Access, version of SQL Server. Prompted data is Company Name, Address, Hardware...

Great, your getting use to the tools. Try looking for a mis-spelled special...spelled specail....that is causing your problems. I left the most obscure error (yet one that commonly happens) till this point. If you use the Explicit option, this type of error would not compile clean. If you need...

Select Distinctrow omits data based on Duplicate Records. If you were to change a value on the results set, Access does not know if it should change just the record selected, or any or all of the duplicates. This query is most likely not updatable. To change the value, you may have to create one...

1) Is the data source a table or a query? A query depending on it's construct may not allow updates. 2) The subform (datasheet) Data Entry Property should normally be No if you wish to do updates to existing data.

You are absolutely correct Bob. SendObjectdoes work with Windows Live Mail. My comment was about coding for Outlook Express. I was intimating the Outlook Express should be upgraded to Windows Live Mail. Ps: Your personal site is great.....helped me a few times!

I thought Outlook Express was discontinued and replced by Windows Live Mail. Or is it just no longer supported? The point I am trying to make, is coding for and out of date Microsoft product is not a healthy thing to do.

Your starting to learn. You caught the TOF error....but did you change it to the correct statement. From Microsoft Help: If you use the MoveNext method while the EOF property is set to True or the MovePrevious method while the BOF property is set to True, an error occurs. You should have...

There are many ways to debug. Here is another if you have a huge amount of complex code. It also helps in testing. here is an example: ......(dim's) Dim bolTest as Boolean bolTest = True ....Code If bolTest = True then MsgBox "Got Here #1 ... My Total =" & curTotal ....Code If bolTest = True...