Search results for query: *

Does anyone know if there is a control to disable the alerts when you append or run an update query? Similar to the one in Excel Application.DisplayAlerts = False It is probably worded differently. It doesnt show that?

I am about 90% done with what I want to do with this application and I dont know how to complete it so it completely works. The code below is from Excel and into my account to a new window where I then need to fill in My email address and then the second fill in box is to browse my hard drive...

Hi Thanks for looking at this post. I have a column in a worksheet that is imported in as 2006-06-24T21:24:22.000Z The first 10 characters is the date. I used one step a Left function to get it to appear as this 2006-06-24 in a new column. I want it to appear as this 06/24/06, I went into...

I been reading some posts about emailing Forms and Subforms, I have a couple of questions about this before I begin. Here is what I am looking: I want to build and email out of the information in a form and subform. Not as an attachment. I read some information about mailing with forms, but...

Hello, I am hoping someone would be able to help me here, I am greatly confused and not sure what I am supposed to do to get this to work properly. I am relatively new to using VBA mostly in excel and tiny bit in access. I created a tool that creates an XML file and feeds it To Endicia's...

I have a table for purchases that I have made for new stock. It access creates the part number for me and I am trying to create multiple labels for the product based on the quantity field of that product. Does anyone know how to go about doing this. Product ID= XXX-My product-123 quantity...

hello and thanks for looking at this post. I have a table that imports sales some of them paid others are not paid. So I have been using Update queries to update the table with Yes and No based on when a customer pays It automatically moves it into a shipping query. I have that down , My...

hello and thanks for looking at this post, I have a question about some VBA programing in Excel. I have some VBA and VB scripts that change the Name of the file that just was created... I would like to take this one step further. Is there a way I can Name a file or choose NOT to name a file...

Hello, hello, I am trying to come up with a work around, for a problem I am having. I am trying to create an XML Feed to feed into endicia. And it does not format properly for exporting in XML to feed into Endicia, I am completely lost with the schemas in XML that is a new beast to deal with...

I am in process of Building an xml feed to feed into endicia for shipping. I tried exporting a file in XML format, It is very close to what I need, But not 100% what I need. I am trying to do some data manipulation in a query and I am stuck. A small example of what the final result should be...

I do understand how the function works, It is simple.... If the value is not this then it then it is that, There is 2 possible answers that can be pulled from 2 different locations, My question is How do you pull more possible answers from even more locations, To merge more than 2 queries...

I have a question about scaling down photo's via VBA Module. I created a module that has this code in it for displaying pictures on a form and all works perfectly well. I just upload the data in a text box. and Picture Dislays. except I would like to make images smaller. It is alot of work to...

I have created a query that when the (memo)text is put together creates a query that goes over the 255 character limit. Everything I did is visible inside the query, and it functions just fine, I would like to export it now and can not figure out how to get all the information to export. I...

Hello, I posted a few days ago about a problem that I was having, I have made some ground with it, but I have a new problem now, Here is the situation: I am trying to create a table or query that shows a count of how much inventory is in a particular area by summarizing the query. I created...

Hi Thanks for taking the time to look at this post. I am trying to build a database to keep track of sales and Inventory. I simply want to create a Purchase order(Outgoing) for products that I purhcase to sell. That Quantity is then added to the current inventory count, and I have to have On...

Hello, and thanks for looking at this post, I am trying very hard to make something execute in access. Basically I have excel xls sheet that I enter in my simple data and it spits out a finished html code for me......... I just started using access a few weeks ago and I am trying to import a...

Hello everyone, This is a great board, I been lurking in the background for a few weeks now, reading learning education myself with the programming. I am relatively new to Access I am better in Excel But like what Access can do so I am making an uneasy transition. I am trying to create an...