Search results

Hello, I have 2 forms Main Form - Carrierfrm Sub Form - CarrerServiceDetailsfrm On my sub form I have 2 cbo's 1st - CarrierTypeID Row Source = SELECTCarrierTypetbl.CarrierTypeID, CarrierTypetbl.CarrierType FROM CarrierTypetbl ORDER BY CarrierTypetbl.CarrierType; AfterUpdate = Private...

Hello, I have searched many forums and have come to a stand still ... yet I know that this can very easy too do .... I have a Form which has a unbound combo box, the drop down displays the list of customers. I also have a OnChange command, so that when a customer is selected a query is...

Thank you. thank you, thank you, and thank you! Thank you for your responses, I did exactly as you stated and well .... it worked! :) i'm still learning Access so somethigns go over my head .... I appreciate the help! thank you again

Hello, I am having some difficulty with creating a foreign key in one of my tables. The two tables i want to relate are ServiceMatrixtbl and ServiceMatrixDetailstbl. I would like the foreign key to be in my ServiceMatrixDetailstbl. I am ...somewhat comfortable with Access .... but I'm...

This is just a suggestion .....but have you reviewed the MS Access sample of Northwinds? that might be a good starting point .....its not a solution but it should give you a general idea .... I know that in the past I have used it and it has helped me.

Is there anyone that can assist me with this ? Thank you in advance

After some further thought ...I'm thinking that I would need to create 2 tables.... Table 1 would list all customers and their corresponding customer numbers ... Table 2 would list all services the customer has based on their customer number.... and then create a relationship between the...

**** NOTE **** These same customers that have multiple customer numbers based on line of business can also be subscribes to various service options with a particular LOB. For example Customer Number - 12345 = Internet = ADSL, Wholesale DSL, Dialup Customer Number - 54321 = Billing =...

Thank you for the quick response! A customer can have multiple customer numbers because they are eligible for more than one line of business ... for example... Customer Name - Abc Inc Customer Number - 12345 = Internet Customer Number - 54321 = Billing Customer Number - 78945 = Data I...

Hello, I have been tasked with creating an "Customer Service Matrix" which will display information such as; Customer Name, Customer Number, Account mgr, and a list of various services they are eligible for. The basic concept I have is .... there will a drop down from which one can...

Hello once again Uncle Gizmo! they are row entires .....in a MySQL db table

I have 3 depts that I would like add,roll,join ...whatever, into one for example ...in my table i have ADSL WHOLESALE DSL Dialup When I run my query I would like them to appear under "Internet" any help is appreciated ...thank you in advance

I Have Access 2007 ...and no I have not done a compact or repair ...

The line it halts on is strDateField = "[UPDATED]"

Yes, I do get an error Error 3070: The Microsoft Access database engine does not recognize '[UPDATED]' as a vaild field name or expression.

Hello, I have a date range form that has Start Date, End Date and Preview Report command button. In the OnClick Event Prod I have Dim strDateField As String in my code that should connect to a MySQL Db, to a table that stores the UPDATED Date. The problem is I can't seem to get the form to...

Hello, I'm trying to create crosstab query and I'm running into some issues. I'm basing the crosstab query on another query...which has no problems... Here is my 1st Query which works (SQL View) SELECT tblDepartments.Department, tickets.C29, Format([C30],"Short Time") AS nTime...

The form itself is unbound, the report that it displays is based on a crosstab query that does list UPDATED Thank you in advance

Oops! ....sorry, thats a typo on my part ...it does read [UPDATED] sorry for the confusion ..... So....I select my dates ..... and then click the preview button and then I get the error Error 3070: The Microsoft Access database engine does not recognize '[UPDATED]' as a vaild field name...

By the I keep getting error Error 3070: The Microsoft Access database engine does not recognize '[UPDATE]' as a vaild field name or expression.