Search results

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

The reason for this number is for a couple of reasons 1 - Sorting the line items on the job ticket 2 - referencing the line when we go to shipping, so it is important that the lines don't change. Once it is line 4, it stays line 4, regardless of deleting items to an order or adding lines. 3 -...

Well I came up with a different idea to get this number to generate, basically every time you add an item to an order, it goes in a list box, and the LineNumber is basically a count of the list + 1, however, what can happen is that I have two lines with the same number, and that is correct, but...

Hello, I am trying to create a database for my business. In one table I have the different items that I sell. In this table I have fields available to put in different quantities that equal different unit prices, aka bulk discounts. I have named the fields "PriceBreakQty1...

I am trying to create an invoice report. I want to add all the costs from the detail section in my footer. I have accomplished this in either the Report footer and/or the page footer, but the problem is that the report footer doesn't go to the bottom of the page, and the page footer doesn't go...

I am struggling to get the value off of an open form into my current form using VBA. I am trying: Me.InvoiceNumber = Forms!Invoices!InvoiceNumber But it is not working. Both fields have the same type, Number - Long Integer. Any ideas what I am doing wrong?