Search results
-
C
Passing data to query from form driving me insane!
Ok sorry guys for the continous asking but WHAT IS GOING ? I use a form to pass data in a query's criteria ! I use [Forms]![Myform]![FormCommand] in the criteria row.So when I open it, it prompts for the value of [Forms]![Myform]![FormCommand].Now I closed Access(2007) and when I opened it ,I... -
C
Query for scheduled service
So for example if you had a car database would you have a table like this: tblcars: .carId .partId .purchasedDate .maintenanceDate Thank you for your responses ! -
C
Query for scheduled service
I see! The thing is that I will enter the data for the recommended maintenance by myself so there will be no use for an append. Could you please advice me how to code the above algorithm in Access? -
C
Query for scheduled service
That is what I thought but the proble is the purchased date. For example when the product is purchased the recommended service date would be : RecServDate= DatePurchased +6 months .But when a product has already been serviced this should be :RecServDate=LastServDate+6months . So I thought of... -
C
Insert from excel to table with look up
Ok now I get it!I used the Control Wizards by now for comboboxes storing the value at prefered place.. Well thank you so much ! I will try your way now :) -
C
Query for scheduled service
Hello everyone ! I'm trying to figure out how to design a service scheduler based on the date a Product was purchased and date that the Product should be serviced based on Manufacturer recommendations. My problem is that I can calculate the date difference between datePurchased and... -
C
Insert from excel to table with look up
Could you please post a sample database on how the tables are and the relationships between them ? +1000 thank you -
C
Insert from excel to table with look up
Please forgive my ignorance but where should I create a combobox with ControlSource of the box to tblItems.fldItemType and RecordSource of the box to tblItemTypes?? -
C
Insert from excel to table with look up
Very nicely explained! I 'll try that and post back , however I think I will have a problem on importing the existing data from excel Thanks for your time! -
C
Insert from excel to table with look up
I 've looked in the Northwind db where in the Purchase Table - Supplier ID field the look up uses fields from Suppliers Extended query . Would it be meaningful to look up (text) values on a query that was created from a related table? -
C
Insert from excel to table with look up
Hello everyone! I'm trying to import data from excel to an existing table (table1) where one of the fields in the table is lookup in other table(table2) which has Number as datatype (bound value) although in excel it is as text, so when I import I get error (unmatched data types).I thought to... -
C
Access 2007 sharing on local network
Is this slow performance normal? -
C
Access 2007 sharing on local network
Ok found out what the problem was! I hadn 't set up the sharing and security on the server side to allow network users to change my files . I also encountered very slow performance (Windows 7 on client - Windows Xp on server). Now it is a bit better... -
C
Access 2007 sharing on local network
Ok who will be able to add data to the table? I ve splitted the database set the BE database on shared folder and now opened it from the client! But now I can't add data to the tables just view already added... On the other hand when I enter data from the FE on the server side the tables get... -
C
Access 2007 sharing on local network
Is there a tutorial on how the procedure should be followed? -
C
Access 2007 sharing on local network
So is there a way to restrict this?