Recent content by AceBK

Hi, not sure if this is a Query question or a VBA one. I am trying to export query data to an xml file but using one of the columns as an attribute. So for example, I am trying to query data from my inventory table and I would like my Material code to be my attribute so I have some sort of...

Well, I just ended up concatenating a number of fields in order to make it work. Thank you for the replies, it is nice to be able to come to this forum and can always count on getting some help.

I am trying to introduce a 2D barcode system in my Access 2016 database. I am using software from Tec-IT, in case that is important information to pass along. I have a query that is pulling data from multiple places, and have a field with 407 characters. When I display the query, I can see...

This might be a simple question, but I am trying to get the name of the Private sub into a text string. I have an error handler in my vba code, but when the error pops up, it does not specify where the error is, since the codes call different private subs. So what I am doing now is changing...

Thank you for the response, I was originally trying to get this to work in the query, but I am just as happy as getting it to work on the report. I made a few adjustments to the code that you suggested, only because it was not quite on the mark. I am posting it here to ensure that it makes...

Hello, I am trying to create a scheduling module of sorts for a sewing facility. I have x number of orders that are listed and have the sewing time in hours in a field. What I am looking to do is add a field that does a running total that will reset when it hits 8 hours. Is this possible? I...

OK, thanks so much for the response, sorry for not responding sooner, my IT department was only able to confirm the status of the CDOSYS files until recently. So we confirmed that this was all working, as well as running some test vba code, but when I run it in the Access Runtime environment, it...

Hello, I am trying to send an email using the CDO method, so when I activate the vba code in my full access program, it works totally fine, but when I go into my runtime environment, on a different machine, it crashes. Am I missing something? Can runtime not run CDO? I am using Access and...

I discovered I needed to run a function, so everytime I select a company on my main form, I run this function which first deletes the query than creates a new one with the following code. I tried running this function without deleting the previous made query, but it won't overwrite it, it will...

I am still quite lost. I have done a fair bit of research on this and I am not getting any further ahead. I have tried making a function to create a new pass-through query but I can't seem to get the function to run. I have the Pass-Through query made manually, all I need is to put in a new...

I am not sure, but that does not appear to be what I am looking for. All I need is to run the query using the account number on my open form. I think it might be easier to have button that creates a new query that will pull in the account number from the open form. I guess what I still need is...

Hello, I am delving into the world of Pass-Through Queries. I have bee growing in my experience with Access 2010, but this is a whole new world for me. We have an Access Database that stores all of our production information but we transfer all the accounting information to Macola. What I am...

I thought of that, but "DocketNumber" is the name of the field that I am trying to find the first record of. It is still there and the name did not change

I have a table called "Company", in this table is a list box of different dockets. When I click on one of the items in the list box, I get taken to my "JobsList" form and it get filtered by the "DocketNumber" that I picked in the list box. So to flesh that out, I have 15 dockets in my...

WOW, this is quite the thread going on here. To clarify, I did want this number to generate while adding records using a form. So in essence, I am recording the number to the table. This number's purpose is to be used mostly as a reference point. When a job ticket is printed off, this number...