Search results

Thanks again Namliam, my problem is solved. John

Thanks Namiliam, could you give me a direction how I can do it in VBA? Thanks in advance, John

I just want to save the new record into to Tbl_A and insert/append new record into Tbl_B, not more than that .... John.

I have two tables Tbl_A and Tbl_B they have the same columns, but Tbl_A has an ActID with autonumber and Tbl_B (ActID = numeric). I have a form "Data Entry" to populate "Tbl_A", how can I do using only 1 command button: SAVED the last input data to Tbl_A and insert (append) the last input data...

Thanks Phile .....

I want to filter out the numbers in a text string in a query, how can I do this? Example: 12a34d36wk11 to adwk John.

How can I visualize a long text from a table (memo field) in a query?

Archiving historical records Hi Phile, I have just this kind of issue where I want to split my main table (Tbl_Claims) and archive the old historical records in a seperate table (Tbl_archive), where I can retrieve it easily if necessary. Could you give me some directions how I can do that? I...

I am trying to use this function, but it doesn't work .... it errors out on this statement "dtmTemp = dhNextWorkdayA(dtmTemp, adtmDates)". Can someone tell me why? John Public Function dhAddWorkDaysA(lngDays As Long, _ Optional dtmDate As Date = 0, _ Optional adtmDates As Variant) As Date...

How can I calculate what date will be (weekends and holidays excluded) looking to the future?. Example what will be the date, if I add 22nd January 2004 by 20 days (excluding Saturday, Sunday and public holidays). Let's assumed that January, 28th and February, 3rd are public holidays. Thanks, John.

Hi Miles, I did change the InputBox using as a form and it works fine ... Thanks, J

Password inputbox Hi Mile, This is what I have written to open up the InputBox Private Sub PW_Click() Dim x As String x = InputBox("PASSWORD:", "Run Report") If x = "drowssap" Then Button63.Enabled = True End Sub Where do I have to add your suggestion? J.

I have created a button which will open up a password inputbox where I can type a password and enable some of other buttons to run certain reports. How can I make my input invisible (*****) when typing the password?. Thanks in advance, John

Ghudson, I have tried to use this: 'UnHide the database window DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowUnhide And I got error 2046: The command or action "Window Unhide" isn't available now. John.

Hi Ghudson, Thanks, Iwill try and let you know John

How can I hide the "Display Database Window" if I open a Form? I don't want to disable from the Startup Thanks, J

Thanks Mile, it works fine .... John.

Hi Mile, The start date is blank because sometimes this field is not needed to be filled in due to the logic of the database. This is a "repair return date". If there is no repair, this field will not be populated and the "reminder date" (repair return date + 10 workingdays) will then give this...

Hi Mile, I got this error message (#error) if the start date is "blank", do you know how I can get a blank result if the date is not fill in? John.

Thanks, I'll give a try John.