Search results

what i would do is to have 2 tables. The first table holding the machine info (so you would have 400 lines) the second table holding the job descriptions for each machines. You would have a link from these two tables so on the ONE form you should have (instead of 30), you select the machine...

What you would need is this Public Function WorkingDays(StartDate As Date, EndDate As Date) As Integer ' Accepts two dates and returns the number of weekdays between On Error GoTo Err_WorkingDays Dim intCount As Integer StartDate = StartDate + 1 'If you want to count the day of StartDate as...

if you could tell us what exactly you are trying to achieve, and why you need to do this. There could be different solution, but for us to find to the best one that suits your needs, we need as much info as possible. If you could also let us know what the tables and field names are called it...

OK what you need to do in each of your subform in the footer section create a calculation. Lets use "PartsSubTotal" as the text box name. In here it should read something like "=Sum([Price])" Do this for both subforms, and remember the names you have called the text boxes. In your main form...

how many tables are you trying to link together... why are you trying to link, and for what purpose

can you post the db?

the way i think you would need to do this is quite simple, fistly you would need to create an append query as you said, which would look at the IDNumber of the records that you wish to move. IF you need help iwth this, let me know the name of the form, the IDNumber field, and the name of the...

i forgot to have an email noticification just in case you needed extra assistance, ignore this message

I have done it in one query, Paste this into the query, in sql mode TRANSFORM Count([General Table].[CLAIM#]) AS [The Value] SELECT [Car Make] & [Car Model] AS Car, Count([General Table].[CLAIM#]) AS [Total Of CLAIM#] FROM [General Table] WHERE ((([General Table].DOL) Between #1/1/2004# And...

i have attached what i believe you require, I have had to use two queries though. Unsure how to condense it to just 1. I have not had that much time to look at it though. If there is anything else please ask. Are you going to do a front screen to enter your date range???

i have sent it to your email account, any issues please let me know. If you are replying to my email address please post a comment here so i know to check it. Hope it all makes sense. Kevin

sorry its taken me a while to get back to you, i've be off work for a day. I will get soomething over to you today if that ok with, sorry about the delay again... someone read my email, and forgot to mark it has unread after they read it.

How much help can i give you???? Or what you want me to give you??? You can do this an easy way, or go the way i think you would prefer to go, so you are learning more quickly. What i can do for you if you want is do something really quick and post it so you can have a look at what i have...

can you give me a screen shot of your form/forms if you have any. In your table layout, if would not work properly because your field types of the MSoffice for example should be a number not text to link to the other table. What exactly are you using this database for. If you could explain...

i've noticed in the relationship window that you have linked the "Name list" table twice, did you mean to do this... You have a lot of tables that only have an IDnumber and a drop down (or so i am assuming) I personally would not do it this way. I would have the table so you are able to add...

try the attachment this will work. Any issues let me know.

if you use the form activate procedure, and in there put some code to refresh your combo boxes, then that should work. So when the user comes back in the form it should refresh the supplier list, due to them adding a new one. Hope this helps.

what you are best doing, is creating a simple form, have a lookup combo box on there, which looks in what ever field you need, then call that combo box "cmbLookup1", then call your form "frmLookup1". erase the parameter quote you have put into your query and replace it with the following...

You could use the keydown procedure Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then ' event here End If End Sub Hope this helps...

I would have 3 tables. The first table containing you Unit number. The second contain the room info, i.e Kitchen, then the third contain the information about the rooms i.e Kitchen windows. This way when a user enters a new Unit Number, then they can enter multiple lines in the 2nd tables...