Search results

I'm send out about 1,000 emails to employees via a VBA code. I need to find a way to have them reponed in a certain format so I can import the replys. They email will be a sarvay of employ info. I do know that the Outlook forms has been turn off as I can not use it. Is there any way for me...

I need the basic of how to creat a single data entry DAP that populates into a single table. I have one day to do this and I have never used DAP. I used the wizard and it created the page (all 8 fields), and set the DataEntry property to True, but I can not enter data. What am I missing...

I have a main form that contains a sub form. On the main form I have a commad button that refreshes and requeries the sub form. I also have a command button that opens a popup form to add new contracts. What I would like to do is have the popup form execute the requery command button on the...

I have a popup form that is opened by users to add a new record into the table. When the popup form is closed I have if saving the records. What I want it to do is requery the main form and find the new record just added to the table. Here is my code tha is not working. If Me.CompanyID <> ""...

:confused: I have a .mdb app that I want to set up to a workgroup. I have a workgroup in the same folder/network on the drive that has a different name then my system.mdw. I have added a new Admin to my .mdb app and removed all the rights of the old Admin. When I run Security Wizard, it does...

It is not that I have tried it with the drive name in the path but get the same error. I use the \\ because different computers have differant paths. By using \\ it will connect no matter what the drive is. Any one else have an idea?????

I have set up a workgroup for an Access 2K db. It is on a network server (NT 4.0 sp5 with Novell). I created the shortcut and put in the path to both the work group and db: "C:\Program File\Microsoft Office\Office\MSACCESS.EXE" "\\Path to .mdb" /WRKGRP "\\Same Path to .mdw" When I copy the...

That worked!!! The =DateValue(Now()) solve the problem. Thank you very much.

I tried the Format also and I still get the same error proble????

The field name is Datetxt. I also tried the Now() function but that put the date and time in which makes it harder to query.

I have a form in Access 2000 that was updated from Access97. The field Date in the table is set to Date/Time with ShortDate as the format. This table is link to an input form and the first field is Date. I have Date() set as the Defualt Value for this field. If works find on some of the...

You may be getting this error if you have not set your recordset to nothing. Dim rst as Recordset set rst = currentdb.openrecordset("") 'When done with rst set to nothing Set rst = Nothing After you are do with the recordset in you code set it to nothing. You if you don't you will lock your...

I have 2 mdb databases. One is the backend that hold all the information, while the second has the linked table in it and is the front-end. I'm trying to write a code that will relink to the back end if the link is lost for some reason. (The back in is on a cd.) All of this is read only...

I have a report that is in Legal Landscape. I export to a snapshot(to save the lines) and e-mail it to my client using a VB program. I have save the setting to Legal and most of the time it exports OK. Sometimes when I export the report it changes to Letter from Legal in Access. Is there a...

I have a Access DB and an Excel spread sheet. What I need to do is have the information, that is enter into the spread sheet, append to my DB. I did not design the spread sheet, and I know there is no table in the spread sheet. This is in a multi-user envoriment. When the user enters info to...

This is my code. Private Function GetSum(GLORG as String) Dim rst as Recordset Dim stSQL as String stSQL = "Select MonthSum Form CMonthqry Where GLORG='" & GLORG & "'" Set rst = CurrentDB.Openrecordset(stSQL) Get GLORG = rst.Field("MonthSum") End Function GLORG is a six diget number and...

I have a data entry form. Sometimes the entry person gose to the next record in the middle of the form. When they get to the next record the cursor is in the the middle of the form. Is there a way to have the corsor goto the top of the form on each new record???

This is my code: Private Function Getpan_wt(id As String) On Error Resume Next Dim rst As Recordset Dim stSQL As String stSQL = "Select display_text From qryPC_BulkMois Where id='" & id & "' And res_name='" & pan_wt & "' And rep_num='" & Me.rep_num & "'" Set rst = Current...

I have a text box were the control source is =Getusrlbl1([sam_id]). When the VBA runs I get a #Error on my report. The code is: Private Function Getusrlbl1 (id As String) On Error Resume Next Dim rst As Recordset Dim stSQL AS String stSQL = "Select usrlbl1 form qurPCincompleteTest where...

Where is the cost coming from. (What table?) Is it the table with the drop box or another?