Search results

Is there any formula I can use to calculate a date in workingdays (excl. weekend). Record has a date value of today (August 4th) +10 days, the result then, will show August 18th. Thanks for example, things like this: workdays(date()+10) ?

Hi Rak, No I haven't got any answers yet to this thread. Sorry!

I have MS-Access 2000 and yes, I know a little bit about VBA. Thanks.

Do you have an example how to do this? Thanks in advance. John.

I have a table with text field which contents multile Sales Order numbers (SO 1234, SO 4567, SO 8901) and customer name (text), is there a way to split those SO numbers and get them in separate lines with the same customer's name?. Example: Customer SO Me SO 1234 Me...

IMO, I do appreciate your help and I will certainly give a try. I'll let you know about the result. Thanks a lot.

Private Sub RunReport_Click() Dim strsql As String Dim qry1 As QueryDef Dim fSQL As Boolean Set db = CurrentDb Dim strSQLAccess As String Dim retval As Integer Dim App As Object strSQLAccess = GetSetting("RT DB", "Replication", "SQLAccess", False) If (strSQLAccess = "false") Then fSQL = False...

I got an error message: Run-time error '2046': The command or option 'OutputTo' isn't available now Can someone tell me what it is and how I can solve this? Thanks

Hi all, thanks for all the nice ideas and will give them a try and come back to you. Again, thanks a million!

The script I have written is supposed to run from a Form with a button (to run the queries). If the end user clicks on this button, the 2 queries will run one after the other in the back ground. Yes, I would appreciate if you could send me an example. I can imagine that the form will close and...

Thanks IMO for your quick reply, but I am looking for a solution without manual input, a kind of solution where you can put a "delay" time of approx. 30 seconds in between before the second query starts to run.

I have an application where I have to run different queries and output to Excel, the problem is (I think ...) that before the first query is completed, the second query is started. How can I make sure that the second query wait to execute before the first one is ended. This is an example of my...

Jon, Thanks a lot ... it works as I want!

Hi Lushman, Thanks for your reply, but I don't know what is variance matrix, I am just a beginner ....

I have a query with a "vendor" field which I can select using the combobox (contains 5 vendors) in a form (Fm_Main). I use this criteria in the "vendor" field to run my query: [Forms]![Fm_Main]![Cbo_Vend]. It works as long as I choose a vendor from the combobox on the Fm_Main, but how can I get...

How can I write a script in Access Database (use as front end) to re-link all the tables with the tables in SQL server automatically when I open the "startup" form in Access?.

Hi Kevin, I think I have solved the isuue. In the Link Master Fields, I put: [Forms]![Fm_Main Form].[Credits] It seems to work ..... I am glad and once again, thanks for your patience and help, Kevin.

I have created an unbound text box "Credits", but how can I link this to the subform using the Subform Field linker?, it doesn't recoqnize the unbound text box in the "Link Master Fields" property?. The control source of the unbound text box: =IIF ([Credit #1] Is Null, [Credit #2],[Credit #1])...

Kevin, I created a query/view in SQL server, but I can not use this query in the Main Form as a Data Entry, it doesn't allow me to enter or change data. I have to add column into the Main Table with the merge expression, but don't know how to do it. Can you help me?. Tx.

Hi Kevin, As my Main Table is located in the SQL Server, how can I add a column in this table to get Credit #1 and Credit #2 together into this column?. I know how to do it in a "view" by using "case when, else, end". But how do I do for a table?. Are you familiar too with SQL?. I want to add...