Search results for query: *

Thanks Cautioun, I appreciate your help, I am little short on lingo still, I have tried many many searches on here an google to resolve that. Perhaps someone can recommend a book. The book is How to Interact with other office applications. I have 5 of them here. 2 with excel 2 with access and 1...

Thanks for the tips, I have a whole bunch of action queries to build a daily report . It prompts me to click okay soooo mahy times,Its Rather annoying. But I definetly fdont want to delete a table by accident...

So If I have that in a userform behind a command key to trigger a bunch of delete, append and update queries, It will apply to all (every single one) applications in access?Meaning other applications?

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?

Yes I got it working, You were right it had to do with the word wrap. I assume thier was carrage returns in the code. I do have another issue currently with this. Which I havent resolved yet. I have been successful with filling out the form. That is not the problem, I see and understand how...

That is pretty neat, I was able to do the Get Fields, But having trouble with the set fields, It is debugging on me. Specifically in 3 places: #1 Set objInputElement = objParent.Tags("INPUT").Item(ActiveSheet.Cells(lngRow, cElement_Name).Text) #2 objParent.Item(ActiveSheet.Cells(lngRow...

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

wow good trick, Thanks very much, I just learned something. That was driving me crazy. Thanks so much for your quick reply

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

One more thing to add, I would like to be able to send the mails out in mass, For example if I need to send shipping notifications. Just click and go and 50 emails based on the form are created.

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

I understand Darrylles. I did something similar to that in a different database. Afterwards. It just effects many other things I have already done. Guess I just have to bite down and just do it. I thought perhaps there was another way out of this.. I do appreciate your time to post and help...

As I was writing back and forth to you, I created a delete query to wipe out the (old) unpaid items so upon import it will re-import the new data(with payment details) Its not my first choice. I am building here... In Time i am afraid it may be a nuisance and slow down the database.

It is not allowing me to import it because I have a Primary key set on a piece of information that would be uploaded twice and not give it a unique value. It goes into other major issues in the database, Inventory, Knowing what exactly is listed on what site.

Yes that is exactly it. Exactly what I am trying to do. I am doing something wrong. Access is not allowing me to do it.

Hi Darrylle, thanks for your post. I will try to make my typing more clear. I know that my typing is poor. I import my sales off the internet. Some may be paid immediately others are not paid and just left in shopping cart and paid at a later time. I am able to run an update query to simply...

I had a similar problem with something I was trying to achieve, I am still relatively new at access , I am beginning to grasp it however I am sure there are better ways to do it. Did you try from the design view of your query (right click) on the line that connects the two tables and then select...

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