Search results for query: *

Below is a typical line of information I have on a spreadsheet: ABC 0 AB 1 ABD 0 RTD 12 TGR 9 What I would like is that when I get a 0 in a field that that whole row can be hiden, is that possible?

I have a table, within which I want to update a field. Currently it has 5 characters within the field, eg: 5TR65 RTE32 I want to delete the 4th and 5th charcters for all recordss in the field. How can i do this?

I have a master table that I import data into each month. Once i have imported the data I change or add certain fields within the master table. When I run the module that changes/adds data to the master table it edits all the existing data. I want it to just edit the newly added data, how...

I have a pivot table that I read data off. The formula used is as follows: IF(ISERROR(GETPIVOTDATA('By Trust and Specialty'!$A$3,"'RespWL IP - "&$B$4&"' "&$A12&" 'Current Month' '"&$D$192&" Total' '"&E$11&" Resp'")),0,GETPIVOTDATA('By Trust and...

I have a workbook that I am trying to open, each time I click to open it, it goes to Excel and looks like it is opening up and everything. Even have the name of the file in the top of the screen. But nothing appears! What is wrong, everything else is fine just problems with this file!!!!

I messed up my security settings within User Group and Accounts, how can I restore these back to the default settings?

I got a field which I want an input mask which forces everything you enter to Uppdercase how can I do this? If I just put > in the input mask it does not work?

How can I get a my form to automatically generate a autono based on two fields: Surname and dob DOB is in the following format: dd/mm/yyyy I want the following for example to appear: SMITH01011980 JONES10121975

I have a main form with a command button which opens up another a sub form. The Employee ID links all the forms together, but how do I get it that when I input into the subform that the employee ID is automatically filled in?

How can I delete a tab order for a field (as the field is a calculated field so does not need to be highlighted for editting?

I want to have the following format when you add something to a field: YYYY/YYYYY eg only allow 2003/2004, 2004/2005 etc.

Say if I have the following fields in a form Field1 Field2 Field2 is made up of a calculation that shows no of days. I want Field1 to be the no of days from Field2 of the previous record. How can I do this?

wl![WAIT_DUR] = DateDiff(&quot;m&quot;, IIf(wl![U_DNA] <= wl![U_Census_Date], wl![U_DNA], wl![U_DDA]) + wl![U_Days_Susp], wl![U_Census_Date]) Is it possible to add the follwoing to this calculation... To ignore the U_DNA when it is equal to or less than the U_DDA. If so how do I fit it into...

I have a report craeted using a table. One of the fields in the table holds data that can either me a 1 or a 2. 1 = Male, 2 = Female. I pull these ones and twos across onto the report. Is there any way of changing the ones and twos in the control source so that the report shows male or...

I have following query within a module. All I want to do is include where Census_Date = NULL then this also is updated with str_censusdate. I don't think <> does this. Create.Execute &quot;UPDATE [WL CMDS (RNA00)] SET Census_Date = '&quot; & str_censusdate & &quot;' WHERE Census_Date <>...

I have a module that imports data from text files and then I need to update the data. But I only want to update the new data that is imported. The module is as follows: what changes do I need to make? Dim Create As Database, wl_import As Recordset, wl_cmds As Recordset, int1 As Long, int2...

I have the following SELECT within a module. What I want to do is update the field census date based on the results of the Select Case. So the module will update the field Census_date to the str_censusdate. But how do I write this in the Update query? Select Case intAnswer Case...

This is a code I have to find a file and import the file. Dim Create As Database, wl_import As Recordset, wl_cmds As Recordset, int1 As Long, int2 As Long, str_answer As String, str_filename As String, i As Integer Set Create = DBEngine.Workspaces(0).Databases(0) Set wl_import =...

THis is a code I have to find a file and import the file. It works all the way up to the: If .Execute > 0 Then For i = 1 To .FoundFiles.Count But I dont know why but it is not picking up the file here and allowing the import to take place. What Is going wrong and how do I correct it? Dim...

I have the following code as part of a module, which I run using a 'RunCode' within a macro. With Application.FileSearch .NewSearch .LookIn = &quot;K:\WL CMDS (Current Financial Year)_\Dudley Group of Hospitals NHS Trust\Inpatient Waiting _List CMDS&quot; 'Below File...