Search results

I have a crosstab query that is dependent on check boxes and feeds a max query. sometimes columns dont exist due to boxes not getting ticked. How can i ignore a field in the max query if its not present. currently shows an error because it cant find it in the mAX query.

I have employees with certain tasks completed and each task creates a new record. I am looking to change the format so all tasks run as colums across the top and have created a crosstab for this purpose but it creates multiple rows for the employee. is there a way to merge the data into a single...

I am looking for help with the syntax for 3 conditions in my query. Basically if [Date] is Null the calculated field called [Status] will be "NO" if [Date] between Date() and Date() +30 "EXP" and if [Date] >Date()+30 "YES" Here's what I've done but can only get it to display the first...

I have an append Query and an Update Query which i run via a button on the form. If i run them manually both work fine but if i run them from the button, the append query works but the update query doesnt as though the append query is locking the record some how but as i said if i run them...

Easy one, I have 2 conditions that will create and "*" when conditions are met. so 3 fields must be NotNull and checkbox must be unticked or checkbox is ticked When i use the or statement all i get is -1 so thinking my syntax is wrong. 1: IIf([Security_Checked_Date] Is Not...

MY query creates a calculated field based on 2 dates.. it takes the day and month from 1 field and the year from another to produce a renewal date. This works perfectly but i am trying to add conditional formatting to this field and it aint working. I am thinking because it is a calculated...

I have a list of folders in a source folder as follows Source Drive John Doe Sub1 Sub2 Joe Bloggs Sub1 Sub2 and a folder list as follows Destination Drive John Doe Joe Bloggs The names are determined by a subform with a list of names so the database knows the assignee name...

I am looking to create a list of folders based on the Assignee field in a query. so if i have 30 records, i would like 30 folders created with the value of the Assignee field in the query. I can do this for a single record but not multiple record but not multiple. Can you Help?

I have a button a form which is a file picker. 1. click the button it opens an explorer window. 2. choose the file, which then records the file chosen in an unbound field in the form called Text3403 3. looks at text3403 and moves the file to another location renaming it to datetimesecond...

Need help with this one guys. I have a calculated field called Classification: when date is null it calculates the word "UNCLASSIFIED" pretty straight forward but i cant quite get the syntax for 2 conditions.. Like if [Registered_date] is not null and [terminated_date] is null then calculate...

I have a date field on a form and VBA after update event if the date field is null it ticks a box, if it is not null it unticks the box.. code works but when i close form it gives me a write conflict.. someone else has changed the record. I have also tried adding me.dirty=false at the start and...

I have a listbox on mainform that goes to a specific applicant when clicked.. ="[Applicant_ID] = " & Str(Nz([Screen].[ActiveControl],0)) the issue i have is the applicant has a subform with more than one record, how can i filter the form to goto the specific record on the subform reported on...

Here is my code but i would like it to report Medium Date Medium Date.. the actual field and table format is medium date. Code: between the" & " " &DateAdd("m", -1, Forms![TRHA]![Medical_Due_Subform].Form![Medical_Due]) & " " & "and" & " " &...

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.

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...

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...

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.

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...

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, "")...