Search results

Is there anyway to do it in a query? This way I can do it dynamically and add the field to the table on the fly and as I may need it.

Yes it will be overwritten every week. I figured I could do the new field in the query like this: RecordNumb: [SQL command to get row number]

Record Number = current number of record I have a table that will be rebuilt every week with new data (batch table). I need to run a query on that table that will start at the first record giving a new field (the field name is BatchSeq) the value of 1 and then incrementing it one value for each...

ASP.Net is kinda the new thing for putting MS Database back ends on the Internet. It is a complete rewrite of the (Classic) ASP engine that MS used to support. There are a lot of great resources as well as some free tools on the Internet for working in the ASP.Net environment. You should start...

Pat to be honest I don't have very good answers to most of your questions. The structure of the tables were pre created by an accounting package vendor my employer uses. I am in the process of bringing all our data out of a proprietary database format and into a SQL Server back end. Most of...

I am back working in Access again and I have a very complicated problem. I am not even sure there is going to be an automated solution to this but if there is I need help figuring out how to do it. I have two tables that I need to make into one new table. Table A is the primary table. It has a...

Hey Jon I am sorry to you go also. Are you working on PHP and HTML exclusively now?

Hey why do things the easy way when I can make them so darn complicated I can't finish my project on time. ;) Thanks an update query was much simpler and cleaner.

Thanks Rich. I was just told that removing the last character is not going to work. I need to remove the 9th character only.

I am trying to spin through a recordset removing the last character from each text value. The values are all - Here is what I have so far but it's not working. Can somebody show me where I went wrong or point me to a better way? Dim objDB As Database Dim objRS As Recordset Dim...

I have seen the Access 2000 SendObject problem come up quite a bit on message boards so I think it is a pretty common problem. I am not sure if this is any help at all but here it is anyway: ACC2000: SendObject Method Fails in Access 2000 Good Luck

Which Version of Access are you using? I believe there is a bug in A2K that caused the email thing to misfire quite often. Believe it or not I am still using Access 97 (although we are almost weaned off Access completely now) and have no problem sending more then 50 emails at a time. Does it...

Thanks for the additional information Travis. I have got a pretty good start on some of my SQL code by using the Access Query Wizard to do what I want and the using the SQL view to cut and paste the code. Of course I have to modify some of it to make it work but that is made a lot easier when I...

Windows with the database set on a network drive and VB as the front end on each client machine. Mainly I am looking for ways to run a few queries in a row. Or say I wanted to do something like this from within my VB app DoCmd.TransferSpreadsheet(acImport, 8, _ "Jobs"...

Has anybody started programming VB.Net as a front end for Access? I have an application where I am currently doing just that. I have some code in a current Access form that I would like to make work in my VB form but I am not sure how to do it. For instance running a query or transferring a...

A bloke eh? I wasn't sure what to make of that so I Googled it. Now I am less sure. Welcome to Bloke-Haven I did find this in the Blokes adviser (well I wanted to know just in case I was one) Bloke: The handbrake wants to drive my car. Bloke's Advisor: No she doesn't, she wants to wreck it...

It did give me the opportunity to update one of the links I included in one of my earlier posts. Ho Du u Instal Actsays????? It was a newbie question about intalling Red Hat Access or some such thing. Anyway the link was dead having assumed room tempature when the forum was switched from a UBB...

It has been a while since I used this forum but it has proved to be an invaluable resouce to me in the past. OutFront Webmasters

You may want to take a look at a sample. Email Report! (2nd Listing) For your case you may want to use some check boxes or a radio button or two to determine who should get an email. I am not sure how your app works so I can not be any more specific. Sorry.

Can you strip down your db zip it up and post it here?