Search results for query: *

On my Switchboard form (frmSwitchboard), I have a listbox (lstRecords) that has 5 columns that are filled by a query that basically shows record informations, one of which contains record numbers. When the user selects on of these records, I want to open a different form (frmCAREntry) but I...

I have a report that is based on a query that gets a field from a table called "Reason." This field is a text field type. I have a text box on my form for which the data source is [=switch([Reason]="AD", "Print Ad")] but this returns #Error and I can't figure why.

I have a report that has different groupings by REASON CODE. The reason codes are stored as two digits, i.e. RA represents "Radio Ad." I would like the section headings in my report to show up as with the representative titles instead of the two digit representations. I am not sure how to...

I have a report that is grouped by week. The Footer for the week sections has totals for walk in customers and sent in parts. I would like for each line to look like the example I have provided. (Monday through Friday range) WALK IN SENT IN 6/14-6/18 54...

I have designed a Form in Word 2002. One of the Text Form fields is bookmarked as APPRAISEE. It is the name of a person and I would like it to appear later in the document. How do I insert another field that references what has been filled in the APPRAISEE field? Thanks

I am trying to Dimension an excel application Dim objExl as excel.application but I get the following error "Compile Error: User-defined type not defined" It seems that everyone else can use this, what is my problem?

I have a Combobox field that has a row source from a table. It autofills as the user types in a name. It works fine except when the Caps Lock key is pressed for example: The name the user is looking for is Ted Beach With Caps lock OFF, you can type Ted Beach and it begins to autofill after...

I have a table with the Following format [Reason],[Date] NS, 12/05/2003 OA, 12/07/2003 NS, 1/02/2004 AS, 11/05/2003 SS, 12/02/2003 OA, 12/04/2003 NS, 2/05/2004 I am trying to build a count query that returns a total for the reason codes in a certain year (2003). I would like the final product...

I use Access to open an existing Excel file and fill in some fields. It then saves it as a new name and closes it. The only problem is when the user opens the new file, they see nothing until the Window is Unhid. Here is my code from Access. Dim strFileName As String Dim...

The following code Hides my worksheet! I don't want it to. Any clues why? Set myWB = GetObject("c:\supplier.xls") myWB.Sheets(1).Cells(3, 3) = Me!txtSupplier myWB.Save myWB.Application.Quit Set myWB = Nothing

We have a spreadsheet that has a StartingNumber column and an EndingNumber column. Is there a formula that will return all of the numbers in between the two?

I have a form in Access that I would like supliers to fill-out and return the information. Right now, we print the form and fax it; they complete it and then fax it back to us. I have designed an excel form that looks similar to the Access form we are using and have locked all the cells except...

I am trying to insert a value (=now()) into a table. Specifically, I want to insert it into an existing record. I have tried using an update query, but with no success; it always creates a new record.

I am copying a record from one table to another (similar) table, using "DoCmd.RunCommand acCmdPasteAppend." I have a [Time pasted] field in the receiving table which has a default value of "=now()" but when I past the record in the code, the date field doesn't fill...can I do this with SQL or code?

I am using the following "application.followhyperlink" method to open an excel file. Is there an easy way to force the file to open maximized?

I am designing a function in a module that creates and instance of outlook to send an email. Sometimes I will want to send an attachment, but at other times I will not want to. How can I make the attachment argument optional. i.e. Call sendemail(,,attachment,,,,)

I am pretty sure that I have seen somewhere how to dimension a number of variables (on one line) that are the same type. For instance... Dim Name, Address, State as string how is this done?

I have a form that auto-generates the date using the now() function. It is basically a tally sheet on which the users record walk-in customers, and products every day. I have a unbound controls on the form that I want to display the totals for the month in each category. I assume that I need...

Having read some posts here, I have decided to rarely (if ever) delete records. Instead, I will move them to a table that stores these deleted records. What is the simplest way to do this? It will be run on the click event of a button on my form.

I am currently filtering my form with the following two lines of code: Me.Filter = "[table]![field] = '" & [tempVariable] & "'" Me.FilterOn = True It is working well, except when the tempVariable is not equal to the field in the table then the form comes up blank and the user cannot go...