Search results

Hi This is about making offers to customers (shipping, dealing with freight) I have two linked tables/form.subform, which i use for creating offers to my clients. In the form, there is combo box from which i chose the area, for example LATAM (= Latin America) or FET (far east) or TAT (trans...

MyCounter = Nz(DMax("MyCounter", "CustomerT")) + 1 Hi With the above line on BeforeInsert event, we can create our own record counter. For example "invoice number" on each invoice or "quotation number" for each sales offer we send to our cliants. The problem is that then, our client, can see...

Example, we can create any pie in powerpoint but we have to type data on cell A2 to A5 and then B2 to B5, update B1 , (risk for human errors) how could we make a link to an existing data source ? Imagine that there would be many pies bars and text, the data source would host all data and each...

I have managed to store all of my business data in an access. Then, from Access, i can extract excel/emails/reports and continue my business easier and faster. The challenge now is "presentation skills" and powerpoint. I need to prepare PowerPoint which outlines volumes from past, forecast etc...

Hi, i want to make a macro in excel, copy range to clipboard Sub Copy_Range_To_Clipboard() Range("A2:D10").Copy End Sub The problem is that the one excel might have just 10 lines while another 100. How could I tell VBA to copy all cells with data?

Private Sub SendMl_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "UpdF2" DoCmd.OpenQuery "UPDT2" DoCmd.SetWarnings True Me.Refresh Dim Msg2 As String Dim Msg3 As DAO.Recordset Msg2 = "Dear team," & "<br>" & "Please find attached...

With M .BodyFormat = olFormatHTML .HTMLBody = Msg1 .To = "me@gmail.com;" .CC = "you@gmail.com" .Subject = "xyzabc " .Display End With Hi With the above, we can tune our email parts, what...

Hi The purpose of this is, we convert several queries to edi and upload immediately to a system. However, the layout of this specific query, contains an number of the record. its record. Because two years ago, when i "tailored" the old database, i couldn't make this AN field, i knew it was...

Sorry if I cause confusion, English is not my mother language. We have one query , imagine any set of record, outlined in a query Say John Abraham Nick Charles Now, we want to add one field with row number and get 1 John 2 Abraham 3 Nick 4 Charles If we use a formula as the below, we...

Yes, i know, why why why this access forgot to add something so simple in query ?

Hi, i mean a row number in a query. The query has a certain sort criteria itself. Then we need to add a row with numbering In excel, you type 1, next row 2 and you auto fill the whole block In Access query, with this i can make row number (id is a/n field) myn: DCount("*","tb1","id<=" & [id])...

Hi, How could we create an increment number on a query when the table doesn't have "auto number" or other similar field? Even if i create one AN field in my table, then, we can create one increment number field on query but this will not be in the same ascending order as the query is sorted...

I don't know what syntax should i use after ".HTMLBody = Msg1 & ", <p>" " There is one existing working perfectly sub (Private sub Opexcel1()) which once i call, one excel pops up in my screen. What should I do in order to see this excel object displayed in the email body ?

Hi, on my form, there is a button that runs an append query. Then, my table is updated. The hazard is that i may click button for a second time and duplicate the records in the table. To avoid this, i have added a text box on my form that counts the records in that table. If text box is >1...

Hi there The below code is the simplified version, the full version is much more complicated with many iifs, however it works just fine, no need to bother you. Then, after email is displayed on screen and user is about to click send, we click another button, <<Private sub Opexcel1()>> which...

Hi In my report that I export from Access to excel, i have two currencies, usd and euro Now, i format $ as "currency" while i format the euro as above port and the result is like this picture. How could I make format of both currencies look the same format ?

Hi The below formats a number to usd currency Columns.NumberFormat = "$#,##0.00;-$#,##0.00" What if we want euro ? I replaced the $ to € and doesn't work, it returns a big black question mark Edit I made a macro in excel, it gave this line "_([$€-x-euro2] * #,##0.00_);_([$€-x-euro2] *...

Hi there When I used a control in the form like below, the enable/diasable function didn't work, when i changed the control with dlookup, it worked. What a crazy strange world we are living in... =[Onesubform].[Form]![Onecontrol]

Hi there I want to Enable or dis-enable a button based on the value of a text which is in the same form, i have typed the below however I am not sure where should i paste these five lines If COUNAL.Value <> "" Then CommandButton2.Enabled = False Else CommandButton2.Enabled = True End If

Indeed the problem was the nature of one field (attachment), after i removed this field from source db, the table was transferred to new one at "tsak bam" mode