Recent content by HotelierDream

So I figured out a few things today, 1 how BAT files work, 2 how to use VBA to write bat files and 3, how to get really good at nesting. That all being said I was able to get the job done with 2 command buttons, a text box and a bit of coding. I am posting the latest version of code if anyone...

I would do this but how would I lookup the name of the file in the directory? It is not the same

I figured it out, new question.... How would I move a file from one drive to another. The original folder will only have one file in it with a random name that will not be consitent therefore I need to move the file in that folder to another and then save it as a specific name, then delete the...

So this? ABC = Dateset.value = Format(date,"ddmmyy")

I guess I am asking, how do I give it a value in the formatted way?

So I need to assign a value to ABC that is the value in a text box on my form but in the format of DDMMYY. So if my form textbox is 12/02/2020 then I need ABC to equal 021220 . Thats what I am trying to do.

When I try that I get this error:

I updated it to this... Private Sub Command0_Click() Dim datasource As String Dim Dataa As String Dim ABC As String Me.DateSet.SetFocus ABC = Format(Me.DateSet.Text, "ddmmyy") Dataa = ABC datasource = "d:\micros\opera\export\opera\rkpcs\xml\mrk" & " " & "ABC" Application.ImportXML datasource...

Also, I need the date to be stripped of the / in between numbers. So like 271220 would be the value if 12/27/20 is inserted.

Mrk is the start of the filed name. The file name is mrk {date}.xml

Perhaps you can help me figure out whats wrong with this code? I get a file path error due to the variable not working correctly. Also, would this copy the format of the previous xml tables? It is the same file just a different day but I dont know how to set deliminators and such using VBA...

Thank you!

Hello all, I could probably spend hours on google finding different pieces of the puzzle to put together but due to past experience I am trying to do this in little code. Here is the deal: I have 2 databases, one for running functions from another, basically FE and BE. The set is designed to...

I could swear I tried it earlier and It didnt work.... now it did. Access is mocking me! LOL Thank you so much!

I am going to try and make this make sense but I cannot promise it will.... I have a table that has transactions on it, there are fields Month, TransCode, TransDesc, Qty, GrossAmt. The TransCode,TransDesc and Month fields repeat as it is just a list of all entries for the month. I want to...