Search results

I looked through the info on DAO recordset and would like to try this. I am not sure how to write the code for DAO recordset based on the code I posted. I wish I could use SQL, but I am limited due to the IT department. I read somewhere another way to improve speed is Extended DLookup, but...

After reading the article it looks like I have one option...to create a replica of the database. Thanks

Yes they are on a WAN.

I have Access database in a multi-user environment over a 10/100Mb network. I am using a DLookup on the Employee ID field to return a employee's workload for a certain date and employee ID. I have noticed the database takes 3-10 minutes on this field for users not located at the same location...

I do have one of the field's control source set to perform a DCount on the table...I am not sure if that would effect it.

The record source is set to the table name.

Yes I am able to add records with the Data Entry property set to No

I have done that and the form opens blank with no fields.

I am trying to figure out how to have a form enter new records only. Currently, my form opens and pulls all the records from the table. I was wondering if it is possible to have the form open with blank fields and enter new records to the table and not display all the records from the table.

Changing the Comments field from Group by to First fixed the issue. I am now seeing all the characters for that field. Ya'll rock! I have been working for hours on this one problem and driving me crazy. Thanks again :)

The entire Group by clause or just hte Group by for the Comments field?

I am trying to generate a query and have noticed that the Memo field Comments is being truncated at 255 characters. I have searched and can not find a work around. I wanted to see if anyone else has run across this and knows of a possible workaround. Here is my SQL for the query...

I have change name of the Date field. Thanks dk and Steve I was not aware that would cause a issue. Steve so far I have not had any problems with setting AllowAdditions back to False before entering any data. Could this present a problem? I have tested it and it appears ok.

Thank you! That worked perfectly.

I have a command button that users click to add a new record. I wanted to add some code that will check the field UniqueID and Date to ensure that the field is not blank. Here is what I have so far. Private Sub All_Load_Click() If [UniqueID] = "" Then MsgBox "Please enter Unique ID" ElseIf...

I have removed the encrypted password and I am using two fields on the tblpassword. ObjectName and Raw. I was hoping to use DLookup to match the Raw and ObjectName.

gemma-the-husky, How would I edit the code to make this work for more than one password? For example if I have another area on the switchboard that Needs a Password, but want to use a different password and ObjectName in the tblpassword. I am thinking that I need to somehow include the...

gemma-the-husky, This worked perfectly. Thank you. Thanks to everyone for looking at this. :)

Here is the database that I am using. Hopefully this helps cause I am going crazy trying to figure this out. :) The password for the Employee Form has been set to page

Editing SwitchboardID and ItemNumber I am trying to implement the following in order to password protect an area on my Switchboard. Here is a link to what I am trying to do... www.daniweb.com/code/snippet216570.html The problem is that when I follow the instructions on lines 85-141 I can...