Search results

SELECT Table02.Id2Order, Table02.Buyer, Table02.Place, LookUp("[MyTime]","tableTimes","[idTime] = " & [table02].[id02Time]) AS TimeNew, Table02.Quantity FROM tblTimes INNER JOIN Table02 ON tblTimes.IdTimes = Table02.Id02Time; I hope it is OK. I've made translation from...

No. Trying to "connect" two tables in query. As I said, with [IDTime] = Integer type it works great. (I've done it just as check experiment) With [IDTime] = Double type (which is "must be") I get ERROR in every record

Hello. I have 2 tables. One is [tblTimes] with two fields, first field is [IdTime], wich is actually a numeric value of, for example, 6/24 = 0,25. --> field size = Double. The second field is text and the value is 06:00. First part of table: IdTime MyTime 0,00000 00:00 0,01042 00:15 0,02083...

Yes, as newer the things are, less convinient they are (they don't bring enough money thru publicity) Nevertheless, As my crosstab query changes with everyday or with evry order I have problem with "dinamically design" of my form. What I mean with that: Names of controls are changed every...

Hi my SAVIOR At first glace it seems that it Works. At least at the level of "data distribution" to records and fields. Now I have to create I form and see if it Works as I wished. Will send results as soon as I try Thanks again

Hello, Attached I send FormProblem.docx file with my problem. From my Access database I get table (which is top page spreadsheet like) From this table (query) I'd like to make a form which would be like the bottom page spreadsheet With my knowledge I'm not able to find solution althoug...

WORKED PERFECT already with the first post ($chr(10) … 1.000 times Thank you :);)

After several attempts I succeed to post "short copy" of the file which is below in my answer. Hope you'll get it

Hello, 1. Tried REPLACE function in query. I get question for vblf and vbCrLf parameters value in pop-up window. Don't know how to put them in query 2. Tried same thing with ….Replace([fieldName], "FindSomething","ReplaceWith") ---> worked perfectly 3. Made form frmForm3, datasheet view. Whole...

I've tried to paste excel file

tblProductsIdProdProdNameDim XDim YDim Z019826DOORS Nolte WHITE X-T-1364/0589-A490FSC Mix credit 1364x589x16572123/013801.364,00589,0016,00019868CEILING Nolte WHITE X-T-1408/0731-A490FSC Mix credit 1408x731,6x16571341/013801.408,00731,6016,00019902BOTTOM Nolte GREY X-T-0476/0293-A490FSC Mix...

To CRONK, to The_Doc_Man tblProductsIdProdProdNameDim XDim YDim Z019826DOORS Nolte WHITE X-T-1364/0589-A490FSC Mix credit 1364x589x16572123/013801.364,00589,0016,00019868CEILING Nolte WHITE X-T-1408/0731-A490FSC Mix credit 1408x731,6x16571341/013801.408,00731,6016,00019902BOTTOM Nolte GREY...

The_Doc_Man Thanks. I'll try to use your suggestion. Not immediately (this is not the main thing I'm doing in the company) but I'll give you the result Thanks

Great thank to you, Mr. The_Doc_man. That is the way I like resolving problems. I'll only start arround the end of your post: 1. well, my general English is not so bad, but when it comes to your, programmers English I become "a little short". So maybe in future I'll post "something stupid"...

It is a .xlsx file. It is not imported to Excel but is LINKED to Access. As my English is not so good I'd need some help from your anwer's last line: if .xls, transferSpreadsheet, then parse the delimited column using a query. Some kind of example would be much appreciated transfer...

I've linked excel file to Access database. The excel file is automatically created by company's software and I can not change it. One column in Excel file is Delimited (Alt + 010). When I link it to Access I get (for example, field "ProductName") long, almost unreadable line of characters. Is it...

Yes, indeed I'm. Especially because I've used some SUB's but never (till today) FUNCTIONS. And now I see what is one of good reasons to use them. Thanks again. Hope you'll be able to help me with my next problem (which will appear for shure) Best regards Zvone

IT seems it work. Thanks, thanks, thanks, thanks, ...........

I made I change as you suggested (from sub to function) and it looks like this: Public Function NewName() Dim Var As Variant Dim N As Double Dim Buyer As String Dim Item As String Dim E As String Dim NameVePlusBuy As String Dim skl As String Buyer =...

I'd like to filter query with a value from my Sub named NewName: ..... NameVePlusBuy = (Version) & " - varianta " & (Buyer) ...... where Version and Buyer are declared as strings andNameVePlusBuy is some kind of combination of both, which I would like to use it in Append query like INSERT...