Search results for query: *

Hi, everyone, I have a form that is building select boxes using select statements to pull data from my access db. However, this method is saving the values selected in the box as one whole string, (I have multiple columns). I simply do not know how to separate the values from the query...

Hi, Scott, I am afraid I didn't have time today to try this out, but I really appreciate your quick reply...the first chance I get to try it out, I will. Looks a lot simpler than most of the examples I have seen... Thanks B

Hello, I have been trying to no avail for the past week to get past what is probably a very straightforward topic to most of you. I am pretty familiar with Access, but new to using ASP on the front end. Basically, my problem is drop down boxes and methods of populating them...

Jeremy, I am a bit confused by the suggestion of 3 queries, but I am also probably not explaining very well. The FoxPro tbls in the directory are named like: YUD123, YUD133, YUD144...these are dumped into the directory on a daily basis, and the numbers are always incrementing. Then they are...

Jeremy, Thanks for your reply. I took your advice and used linking instead of importing. And I actually did figure out how to step through a directory containing many (FoxPro)tables and link each one, and it works great. However, I am still perplexed on how, within my same loop,that once the...

Hello, I am trying to work with a directory that contains FoxPro tables, and bring them into Access. Sometimes the directory contains 1 table, sometimes 2 or 3. I would like to import, rename, then append the tables to a master table. I am quite puzzled over how to go about it, though...

Hello, I am a bit confused by a process I am trying to implement. I have a directory that receives uploaded FoxPro tables/files on a daily basis. I am trying to create a connection, and run a query to append the most recent file/table to a Master table in my Access db. Because they(the...

This is great...a GetDate function as you mentioned is exactly what would make this functional, in that the user is only interested in doing processes based on the create date of the file....I VERY much appreciate your input,and your taking time to post. Thanks!

GDGarth, Thanks for the direction. I have a clearer idea now of how to proceed based on your suggestion. Thank you for your time.

Hello, I am just wondering if it's possible to do either of these two things? 1. Automate an import when your source tables are all separate, such as with FoxPro tables...or 2. Have the import be manual, but append the (newest)data automatically into a master table. The file names of...

Thank you, Wayne, you rock! Works beautifully!

I am wanting to use criteria that matches only the left 3 characters of the value in an input box on a a form, but am not having much luck...syntax I am using is Like Left([Forms]![frmMyForm]![txtMyTextBox],3) or just Left([Forms]![frmMyForm]![txtMyTextBox],3) but it's not returning any...

Thanks for your reply...I had a syntax error that your suggestion pointed out to me...however, now when I run the calculation, it tells me the recordset is not updateable. My form is based on a query with 3 tables, however the calculated field is only referenced later in an update query. Can...

I have a calculated text box on a form. I want it to display 0.00 if the calculated amount is less than 0.00. Wouldn't it be If TextCalc.Value < 0.00 then TextCalc = 0.00 Or something to that effect?

Thanks for your help and suggestions, it just worked after I looked a little closer at my criteria, so again, thanks Lonnie and FoxProProgrammer for your time. This site is great!

I have tried both with and without criteria...with criteria being while its =[Forms]![MyForm]![txtField]...and am still not getting any data in my table. This is one of those glaringly simple things, I am sure, but I don't know what I am doing wrong....

I have an update query that I am using to send the values of a current record on a form to a table, and I am using the expressions of [Forms]![MyForm]![txtName],etc.in the Update To: with my destination fields in the table specified...I then would like to run this from my active form...however...

Thanks to all those who replied. Yes, I am trying to link a table with name values-ex. Joe Smith to a table with name values J Smith. And there are no other fields to link by. You guys helped me answer my question, no fuzzy logic is allowed in a join. I will concentrate on the suggestion to...

I have two separate tables that need linked by a name. The name fields have different input in the tables, so I was wanting to modify the join type to be &quot;like&quot; the records in table b, instead of equal to. I have tried to do this in the SQL window without much luck.

I need to import the calculated value into 3rd party software which only allows ODBC from table fields. That's why I need to store it in a table first. I do appreciate your suggestions.