Search results

Hello, Am trying to change the forcolor of text in a label on a form based on the value from a report. I have added a text box called (Indicator) on the form that shows the same value from the report mentioned (control source: =[Reports]![rptIndicator]![AccessTotalsRevenue]) The following...

Hi everyone, may you please help me on my above issue i have many tables that are the tasks of a project, each task has its details, and one of these detail is the people that participated in each task. In some cases only one person performed a task and in other cases more that 5 performed a...

I think i found a solution for it, just set the prperty to hide duplicates its not the best solution but will do i guess. If there is a better way for it to be done will appreciate it regards

Hello everyone, I have many tables, these tables are details for each task of a project, (example, translation, directing, typing, etc...). The project has an ID number. Most of the tasks are performed by a signle person, but some have more persons. I am trying to create report to show all...

many thanks guys, therefore it is useless to have a button to close the form and ask if i want to save, as saving happens automatically thanks

Hi Everyone, I have a main form and a subform, I created a button to close the form and popup a msgbox with vbYesNoCancel if i need to save. All is working well, but when changes are made to the subform and close the form from the button, it is not working properly. When I choose not to save...

thanks Kwah, i have looked around the web, and found out that a report cannot be refreshed, always have to hit the refresh button thanks again

Thanks, this will refresh the query that will will run after changing the combobox value? The query will run after choosing a value form the combo box and hit a button it works fine when i first endter a value from the combobox and hit the button, but if i go back to the input form and change...

Hi Everyone, I have query that runs from an input form, everything is fine, but when ever i got back to the input form and change the value of combobox, where the query has change the records it gives it wont do this automatically i have to hit refresh button on the query to the new result, it...

Many thanks Ruralguy I tried this and it worked perfectly many thanks again

Many thanks Jan & Gemma, It worked perfectly, I only added the .column(1) after DispatchBy But still trying to figure out the exact meaning of it Many thanks again all the best

yes it is a combox, the row source is; SELECT [tblCourierCompanies].[CourierCompanyID], [tblCourierCompanies].[CourierCompany] FROM tblCourierCompanies ORDER BY [CourierCompany]; The Bound Column is set to 1 thanks

hello I have a combo box (DispatchMethod) that has a row source type of Table/Query, which is linked to a table called courier companies, and i can select FedEx, Aramex, UPS, Email, Satellite I want 2 field boxes, which are AWB & Tape Format to be disabled when I choose email and only AWB to...

Thanks for your reply JR I dont know how to post a sample, and i dont want to hassle you with this too. I added the debug.print, but nothing prints on the immediate window? thanks again

Hello again, I am not very sure how to change the value to the viewed instead of the stored. However i tried it on another database, where the values are wriiten manually rather than getting these values from a related table and it worked perfectly. Please help on how to make it work while...

Thanks JR here is the code; Private Sub DispatchBy_AfterUpdate() Select Case DispatchBy Case "Email" Me.AWB.Enabled = False Me.TapeFormat.Enabled = False Case "Sattelite" Me.AWB.Enabled = False Me.TapeFormat.Enabled = True Case "FedEx", "Aramex", "DHL" Me.AWB.Enabled = True...

Hello, I dont know if i am correct, but I am writing a Select Case statement or and if then statement, but it does not seem to work if the source type is a table/query type, which is linked to a table? if so, is there a way the select case can work while keeping it in a table/query row source...

Hello, I dont know if i am correct, but i am writing a Select Case statement or and if then statement, but it does not seem to work if the source type is a table/query type? if so, is there a way the select case can work if the while keeping it in a table/query row source type? many thanks

Hi All, I am having a problem with a select case the code is Private Sub DispatchBy_AfterUpdate() Select Case DispatchBy Case "Email" Me.AWB.Enabled = False Me.TapeFormat.Enabled = False Case "Satellite" Me.AWB.Enabled = False Me.TapeFormat = True Case "UPS", "DHL", "Sky Net", "Aramex"...

what is happening after adding the select case. when i go back to the form, it is keeping the disabled boxes disabled even when i select an option that should have these boxes enabled so it seems that the code of having the AWB and Tapeformat disabled on forms currect event is being superior...