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

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

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

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

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

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?

How to explain my issue, I will try my best. I am building an Access 2010 Database for a business. I have learned that I have to try and not duplicate information so I have three main tables. The first table is a list of the Jobs linked to customer info and contact info, I call it JobsList...

I am trying to come up with automatic line numbers for each specific order. So for example, I have job number 123456 that has ordered 3 items, what I would like is that item 1 has a field with a 1 in it automatically, and item 2 has a 2 in the field and so on. But the trick is that when order...

I am trying to make only one field required, but only for specific customers. So in the customers table, I made a check box to determine if this field (RefNo) will be required for this specific customer. In the Orders form, I have included the check box from the customers table so that when I...

I am not to sure how to explain my issue, but I will try my best. I am running a query for an apparel manufacturing facility. In my query I have a table called 'OrderForm' which is where the orders are put in. There are more than one type of fabric that can be a part of an apparel item, so as...

Good Day, I have a rather interesting problem/question. I have been working in Access 2010 and by no means would I call myself an expert. I have two different tables, one is called 'JobsList' and the other one is called 'StatHolidays'. On the Jobslist form, I have a field that requires a...

Good Day, I have put together some Access 2010 Databases and I am about to embark on another soon. I have been given a request that I can't seem to solve yet so I am goint to ask it here as a good starting point. The goal is to build a database for a magazine. They want to be able to run a...

I am working on an order form for production. The Docket allows you to add multiple lines for the order and perhaps the Sales rep would like some pictures taken of some of the items but not all of them. I put in a list box with "Yes" or "No" on the form. On the report I have put a picture of...

I have found the macro to send reports to an email address, the big question that I have not been able to find an answer to is, can I set a "Reply-to" function through an Access Macro? If not, how do I convert just the one macro to VB code and what is the code for the "Reply-To" function. Thanks,

I have a database that is tracking donations for my organization. I have some members who donate the same amount every month. Is there away to copy the records and paste them with the current date in the "Date Paid" field, and do this "Update" once a month? As opposed to typing in 200 records...

Good day, So I am continuing to build my database and have learned so much already. I am trying to implement a username and password system on my DB. What I have done so far is created a table with username, password, permission level and datestamp. So when the db is opened, the form pops up...