Search results

Hi every1, I have to create a macro to automate some procedures. I know some bits of it but sometimes I'm just confused. The macro should: 1. run query (the query will create table tblDatesDifferences) 2. open table tblDatesDifferences 3. add new column 4. rename column for EndDate 5. change...

Thanks! I know what you mean. Can I create a macro that will perform all these tasks for me automatically? So that the user could do it with one click of the button? Thanks again!

Hello, I have a question. Is that possible to find a number of days between two dates BUT if those two days are from different record? (if we assume that dates are in ascending order) (uk date format) For example: StartDate EndDate Record 1 01/02/07 28/02/07 Record 2...

Hi guys, I know how to count records so that null records would be counted but I do not know how to do this: I have customers and works. I want to create a query that will show ALL customers and number of works done for that customer (sometimes there is no work done for customer). How can I...

Hi, The expression you gave me is great and I am going to use it anyway I just wonder to find out what the function for that is. The use of “Case statement”. Thanks a lot!, Regards Matt

Hello, Sorry I was away for a while. The database you attached is not up to date and I have changed layouts and add new subforms and tabcontrols. I tried to changed the data types to a autonumber and then to re-establish relationships but there still seems to be a problem (or I’ve done...

Here it is. try to add new record to tblcustomer using the frmCustomersDetails. And btw..I deleted one field from tblWorks and now the forms ask for that field. I removed that from queries etc. and the problems still occur. Thanks! Regards Matt.

Thanks! I used that in my query and it works:) But I still would appreciate if you could give me the VB code for my form. Thanks again! Matt

Hello, I am looking for a code that will be showing the status of the work I’ve got. I have 4 text boxes on the form: StartDate ; EndDate ; CurrentDate and WorkStatus. The StartDate and EndDate are linked to the tblWorks. As the default value for CurrentDate I have =Date() . I need a code that...

Hi evry1, I want to create a form that will be showing the status of the work i.e: work done, current work and future work. I have “start date” and “end date” for each work. I want a text box that will be showing if that is a current work, work done of future work. Does anyone now what code...

Hi again The combo box works fine. But I have another problem now. I have used subforms to show some information regarding customers. They are also depended on that combo box. When I choose customer, subforms show correct information (about that customer) . but when I want to edit data or add...

Thanks, that's great! :) It wasn’t so complicated as I thought it was. Thanks a lot, Regards

Hello, I have created the combo box to select the customer lastname in my form, so that the rest of details of that customer appear. However the problem arises when 2 customers have the same lastname. Well I could use the record selectors to change between them but I would prefer rather the...

I really stacked with this. If anyone have some ideas please let know. Thanks in advance Matt

Hi everyone, I tried to search this forum for similar topic but I couldn’t find anything that would match what I need. I have 2 tables: tblCustomers CustomerID FirstName LastName HouseNo Street PostCode Town tblAppointments AppointmentID CustomerID Time Date NouseNo Street PostCode Town The...

Hi, I have one more question. What can I do (probably something with query) so when I use the Register first the dialogue box appears and asks to enter the class ID. And then on the list of members are just these members who are in that class. I tried using this: SELECT tblMembers.LastName &...

Sorry, the changes you have made were correct:) You just specified rst!AttendanceDate = CDate(Me.txtToday) I will use just Me.txtToday as there my be some updates. So when I change the date in the txtToday the register will update the table. If I would use rst!AttendanceDate =...

Thanks for checking it :) Well I tried use the register after your modifications and it still did not work. Besides I just realized that the structure of my database is completely wrong :( There are some integration errors in the tblGrading when choosing the instructor and also in the...

Hello, I try to create an Attendance Register, It's to many to write so I would appreciate if someone could take a look at my database and try the Attendance Register in the forms section. Just select the student(s) and use the button. The error msg appears: 3061 – Too few parameters...

I have made changes as you said and everything works well :) Thanks a lot, Matt