Search results

that worked great here is what I did. UPDATE tblEvent SET Quanity = 2 WHERE Product="TV"; One more question is there a way to set this so if there is already something in the quanity field it will not be overwritten.

Is it possible to use a update querry to enter data into a particular column. For example the table has 10 rows. The first column is autonumber the second is Product. The third column is the one I would like to update. It will be updated with a 1 or a 2. The products are tv, stereo...

I played around with the filter by form and it looks like it would possibly work, but I need to create a form that will be simple to use as this operation will be used alot. I have been reading somemore and I believe I might be able to use a update query but not exactly sure how.

I have a table with 4 columns. ID Date Category Product Price The table has information in the first 4 Columns. I need a user form where you can select a particular; Date, Category, & Product from the table. Then have a text box where you can enter a Price. There will be a Command...

I have the following columns; ID, C#, Date, Master, L1, U1, O1, S1, T1, J, L2, U2, O2, S2, T2, L3, U3, O3, S3, T3, L4, U4, O4, S4, T4. The Master column will have entries; 1, 2, 3, 4, 5, 6, 7, or 8. I need a user form that will run query and a report. In the user form there needs to be a...

There seems to be a bug with imsg. If you dont put text in the body of the email the attachments lose all formatting. The code below works.ChDir "c:\Temp1" ActiveWorkbook.SaveCopyAs Filename:=Range("FF1").Text & " Closing Sheet" & ".xls" Dim iMsg As Object Dim iConf As Object...

I have a table with many columns; Master, L1, L2, L3, L4, P2, P3, T3, U, . The Master column will have entries of 1-8. If the Master column is 1, then the report needs to pull column L1. If the Master column is 2, then the report needs to pull column L1, L2, & U It goes on like this with...

I have it fixed but when you recieve the email it is losing some of the information in the spreadsheet. All the code and macros are still there. It loses whatever data that was in the sheet and the formatting. Any suggestions?

I have the following code of which I have a button on a excel worksheet that is supposed to email the active sheet. I can get the email. I can even get attachments. I just can't get it to work properly with the active sheet. Any help would be greatly appreciated. Thanks Sub SendMail()...

http://www.access-programmers.co.uk/forums/showthread.php?t=161685 The link to this thread will show you how I fixed this problem.

I have a table with the following columns Type, Sport1, Team1, Score1, Sport2, Team2, Score2, Sport3, Team3, Score3, Sport4, Team4, Score4 If Type = 1, 2, or 3 Then there will only be information in Sport1 and Team1 If Type = 4 or 7 Then there will only be information in Sport1, Team1, Sport2...

thank you I figured it out with using a on load event procedure for the form and the following code. Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub

Thank you for your reply. There was a macro in a query that was not working and when i deleted it. The code windows were no longer open in the background and the db works fine now.

I have a db with 9 different forms all very similar. Each of the similar forms has a log bet button on the bottom of each page. When i open the db up and go to click log bet it returns a event procedure error. When i open vb up it has the code open for 2 forms; line and under. If i close...

Set the default value to what you want to post. Thank you for your help.

Thats were im lost how do i do that?

Making the field not visable will solve most of the problem. But I need a field in each form that will always post the same data to the table. For examble. Form1 Logs data to Table1 The field could post a 1 in table Form2 Logs data to Table1 The field could post a 2 in...

Is there a way of doing this without adding another field to the form or at least not a visible field?

I have several forms that are similar. They all log data to the same table when the LogData button is clicked on each form. Is there a way to assign a value to each LogData button in the different forms so when the data is logged i will know which form the data came from. Thanks

I am a newbie with access. I would agree i dont need the extra column but how do i get the toggle to post 10% instead of 1.