Search results

I have minimal experience creating a form and no experience with VBA. I have version 2007. I don't really need a form, I need help with the VBA code to transferdata from Excel to Access on a large scale and automated. Manually updating 250 spreadsheet connections everyday isn't an option for...

Guus2005, Thanks for the sample. The problem is that its entirely in greek to me. I added a sample table but don't know what to do from there. Can you give me some more help? Thanks

I have excel spreasheet that have dates on them. But the dates are formatted as general so they are really only numbers to Access when I link the spreadsheet to a table. I was hoping that I could create an input mask that would make Access recognize that the numer 20070912 is really September...

I have a similar issue that I am trying to do. I have daily downloads of data that come in separate excel spreadsheets. I would like to import them all to a single table daily and then update the table with today's numbers from each of the spreadsheets. If this code that you spoke about would...

I have to have a multivalued thread because I only want to have one record for each person. But each person works in different zones. For later query purposes I need to be able to find all the people that work in a specific zone. I am going to have a data entry form eventually. How will that...

I need to have a field that is labeled zones. This field can have anywhere from 1 to 7 or so values. The Values are numbered 1-15. If I have a person that operates in zones 2,3, and 4 I need to be able to have the annotated in the record so that when I want to see all the people operating in...

I subscribe to a data service that sends me ascii format files everyday for commodities. Each contract month is in a separate workbook. The new data each day is just tacked onto the last row of each spreadsheet. All the spreadsheets are in a folder. Ideally I want to take all the data from...

I'm the first one to agree with you conclusion. The problem is that I have to get the data from a data service. Unless you know of a way that I can have this data go directly into Access, I have to use excel as a stop over point. I am well aware of the flexibility in excel's formatting...

I have recieved some suggestions for using VBA to perform the daily updating of my tables in access. The problem is I don't know how to interface VBA with Access. Can someone please explain this to me? I need to be able to update a large number of tables from excel everyday and somehow using...

O.K I don't have an experience using VBA. Can you explain how I use VBA code inside Access? You said I could use a FILE SYSTEM OBJECT command but I don't know how to use the VBA code once I create it in a module. Can you help me understand how this works? I was hoping that I could create a...

I am trying to create an input mask for a name field. I have Spanish names with two last names separated by a hyphen, a comma after the two last names, a space, and then the First Name a space and the Middle Name. The First Last Name needs to be in all capitals like the example. Example...

O.K. I figured it out. I was missing one part to make it look at today's date and then see if the close was greater than the range of the last 20 days. Thanks for all your help. But of course we are not done. Is there a way to apply this to multiple tables? Since I have 200 that I would like...

I copied the formula and it gives me a data mismatch error message. I think because you have two criteria that have to be reached. It doesn't seem to like having criteria for the date (to get the range of last 20 days) and the max of the close. Any other ideas how to write this?

I am trying to write a breakout formula to identify if today's close is greater than the maximum close of the last 20 days. This is what I have so far: SELECT WZ07.Symbol, WZ07.AlphaDeliveryMonth, DateSerial(Val(Left([ddate],4)),Val(Mid([ddate],5,2)),Val(Right([ddate],2))) AS transdate...

I have at least 200 excel spreadsheets that get updated every day with closing prices of commodities. I want to run a breakout query against every spreadsheet to see if today's close is a new 20 day breakout. What is the best way to organize the access table or tables? Put all the data in one...