Search results

Yours was the gift that kept on giving DJkarl. You solved my problems as well...thanks!

I keep getting Run-time error of '1004' or "cannot be found". I double checked my folder names, filename, and macro name and all seems well. Not sure why this is happening. Here was my code: Private Sub open_excel_formatting_Click() Dim objXL As Object Set objXL =...

I'm trying to do the same thing here. When running the code below off an On-click event I received a "Run-time Error '424': Object required Sub On_Click_Run Excelmacro() objXL.Application.Run "P:\ROC Reports\Network OSP Reports\QAM64 Migration\files\Formatting_macro.xls!format_cf" End Sub...

Hey! I figured this out from another thread. By moving my code from the On Open event to the On format events for each report section I was able to make the fields invisible. Now to see if I can re-align objects too! :rolleyes:

Conditionally displaying fields on a Report I have a problem similar to this one for a report I have created. I'm using the same basic report for three different employee types: analysts, project managers, and team mentors. I'm trying to hide a field called "Days" on the report when the...

It appears that on the Form_Click event I need to open the recordset of the search form and copy the recordset to variable rs. I then need to store the selected value, in this case it is the value of the field TaskID. Then I must clone the recordset of the other form frm_recordentry and search...

MStef, Thank you for the reply and that information, but I do not want searches initiated from the main form. I know that Access is capable of doing this, but this is not the design I am pursuing.

Some of my users have asked that I create a simple search form that will let them view several fields for each record and then select the desired record using record selectors along the left edge of the form. Once clicked, I will use the Form_Click event to display the same record on the main...

Nevermind..figured out. Here is the code in case anyone else might find this useful: Dim rs As Recordset Set rs = Me.Recordset rs.MoveFirst Do Until rs.EOF 'loop through our query created above If [fldIsLocked].Value <> "Yes" Then [fldIsLocked].Value = Yes End If...

Hi all! Looking for some code help here. What I'm trying to do is change a value on all records once they are returned in a query. I have a yes/no field that I want to set to "yes" once the query returns the initial recordset. By changing this field to "yes" on all the records the idea is...

Here is the scenario. I am creating a database to track tasks. On the main table, tbl_tasks are the following fields: tbl_tasks *TaskID [autonumber] TaskName [Text] CreatedBy [Text] RequestedBy [Number] tbl_requestor *RequestorID [autonumber] FirstName [Text] LastName [Text]...

The problem here is that the data source is limited to .csv exports so I can't export the data as space delimited or any other format. To add insult to injury the field called "description" often includes several commas which can incorrectly offset all columns improperly. I don't have a...

This seems fairly simple but I am doing this wrong. I am somewhat experienced in Excel VBA but perhaps because I am making the call from Access I am missing a step here. I have a number of files (usually 5 but the number may vary) that are saved in the .CSV format. I want to open these and...

I am trying to avoid using the DLOOKUP function due to the impacts it has on performance (load times). This is especially prevalent on a not-so-fast-network connection. I have a form based off a query that itself is sourced from a table of work orders. There is another table that houses...

Thanks for the reply Brian! That worked terrifically!

I am trying to avoid the creation of a lookup table where I know I should be able to calculate this. I need to determine the start and end date of a week number. I did find this post from 2002: http://www.access-programmers.co.uk/forums/showthread.php?t=33116&highlight=start+end+dates+week but...

Thank you again Bob! That worked like a charm. Now let me ask you, is it safer (in a multi-user environment) to open a query recordset as opposed to a table recordset and then insert my record? When opening the table would I not also be locking the table from use by others? Will that cause...

I have a main table used to track project details. Related to this table is a table called, "tbl_dates" which houses all project dates. The dates table looks like this: DateID | DateRefID | DateEntered | WorkOrderID These four fields store Field 1 - (PK) DateID: which is an Auto-number for...

gemma-the-husky, See I thought that "As Date" portion of the declaration for NextBizDay() would define NextBizDay as a date... Public Function PrevBizDay(intNumDays As Long) As Date

That worked RuralGuy! Thank you so much. Initially it failed but I soon realized that you missed changing the Workdays variable to "NextBizDay" in the statement where it checks to see if the Weekday is <= 5 and where the format is applied for the Dlookup. Not a big deal... So I guess what...