Search results

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...

Hi Arnelgp. GREAT THANKS WORKED PERFECTLY FIRST TIME. Just question: Why you used char(34) instead simply " Best regards

Nothing. Just Name

Hello. I have a PEACE of code looking like that: Dim ElKup1 As String Dim sq As String ElKup1 = (Forms!frmNotInList!Combo6.Column(1)) & " " & Forms!frmNotInList!Combo0.Column(1) sq = "Update tblElements Set ElementName = ElKup1 WHERE ElementName=null;" DoCmd.RunSQL sq When I run the...

I think Ihave resolved the problem. You helped me to find out that I don't need indexes. I've used "syntax" like follows Combo0=i where i (as integer) =DMax("[ID]", "tblNames") Thanks to all for help:)

No. "Joe" is unbound column. ID of "Joe" is bounded