Search results

I have 2 date fields in a subform and code that if [Date_Field1] < [Date_Field2] it displays a hidden button . this works but i would only like the button to show if [Date_Field1] < [date_Field2] +30 days. Cant get the code to work by adding +30. where am i going wrong? Thanks.

yeh can see this working.. for some reason when i choose a filter or reset it back to original query i lose the conditional formatting. i f i use a solid colour and not the bar its fine. must be something to do with how it compares the record set. i will default to a solid bar. this works.

In the end ive gone with RanMans Pointer. Why i never thought of this ??? worked a treat. Thanks again and thanks to Gasman for you input.

I am looking to filter a date field by month based on a form. I have a combo box with 1 Month, 2 Months, 3 Months, 6 Months, 12 Months. If i choose 1 month on the form i would like all records from todays date to next month. If i choose 2 months on the form i would like all records from today...

I have an issue with conditional formatting. This is a simple rule when the field is populated with a number upto 100, it has a green bar that goes up based on the value. works fine when i open the continuous form but if i then use any filter buttons, the conditional formatting doesn't work...

yeh did think of this. table_1_ID is autonumber and table_1_Cont is not. so when table_1 creates the ID how do i get table_1_Cont to populate the ID field with the newly appointed ID but take the data from the copied ID.

I am looking to append to 2 tables based on data from an existing record. Due to the amount of fields i have had to spread data over 2 tables Table_1 and Table_1_Cont. Table_1_Cont is populated via a subform linked By ID to the mainform so when data from Mainform gets populated to table_1, data...

Not quite that simple... i have a text field on the form labelled " increase rates by %" how do i reference the query to this.. tried * 1.0 & Forms!aaaaa obviously the wrong syntax.

Yes Yes Yes... I have a template table and an append query that populates a rates table with start and end dates.. all i need to do is add a percentage increase to the templates table.

quite a lot.. lots of rates lots of jobs lots of stuff going on.:D

where in this code does it reference the table to be updated..

ideally i will have a text box on a form.. input percentage increase value, hit the button to run the query and update the data.

I have a rates table with different fields for standard, overtime, weekend etc.. We have an increase of say 2% on all rates across the board. how can i create an update query that can increase all Rates by 2%. Any help is appreciated.

Both 32Bit

Whenever i Compile and repair my front end i get error half way through.. "AO Index is not an Index in this Table" i click ok and find most of my table links, forms and some queries have gone. the database is then unusable. luckily i have a backup before the compile and repair so can restore...

May be a stab in the dark but it worked a treat.. :)

I have a query data that imports into a word template using bookmarks. What would the syntax be to import date field as long date.. currently defaulting to general date on the word doc but long date on the query. WDoc.Bookmarks("Client").Range.Text = Nz(rs!Client, "")...

Got it working. Thanks for your help much appreciated!!

Genius! works a treat. is there an easy way to change the formatting date... currently displays as 1/1/2019.. no option to change format to Medium date.

Feb 29th has never come up :) Example: Anniversary Date: 26th April 2012 Client has 6 records in a Sub report last record was created 2018 with a completed date field of 17th April 2018 so Due Date should be 26th April 2019 but DateSerial looks at anniversary date and returns next years date of...