Search results

Hello, I'm hoping someone can assist me with this issue as I have been working for 5 days on this. I am trying to calculate the total time for 1 day between 2 times and subtract 30 minutes for the break. Then I need the sum of the time for the week. for Example: Johnny worked 2 days, on day 1...

I am trying to export a table that includes a field with a hyperlink. The table exports just fine and with the hyperlink. However, in Excel the hyperlink address isn't there so when I click on it, it doesn't open the link. I can manually edit the cell but I want the export to already include...

Can a database developed in MS Access 2003 be opened in MS Access 2007 without converting it?

Hi ,, I tried the DoEvents to no avail .. its still chopping off the string. I don't understand why.

Hello all and thank you for your replies. First, I am only doing a debug.print to check if my code is giving me the correct string. Second, it is a HTML string that I'm creating to provide to another function that uses HTML to format an Outlook email. Initially, the code works but it cuts off...

Hi, I have a public string variable that I pass a string to from a function. The string is not a fixed lenght. When I try to use the value stored from the public variable in another function, it chops the length of the string off. How can I pass this variable with the fixed length? The...

Hi Yes. The cancel event worked better. THank you.

Hi, I need to send keys to escape 2 times. How can I achieve this? Here's my situation: On my main form, I have a subform which displays 3 fields and the form is set up as continuous. On beforeInsert of the subform my code checks for empty fields (required) on my main form. If it finds...

Hello all, I was wondering if it were possible to connect to LDAP and created usernames and passwords based off of the LDAP username and password? For example: When I login a secured database I want the username to be the same as my windows log in and the password as well. Currently, when...

I have a crosstab query that I'm using as my source for a bar graph. I want to show the total of events that occurred between 1/1/2011 and current. So my fields in my query are setup as follows: [EventTitle] - group by - row heading (Format([DateEvent Began],"MMM 'YY")) - group by -...

Yes. I have plenty of code behind the main form. Not any code on the subform's before or afterdelconfirm events though.

Can anyone explain to me why my delete event displays the confirmation twice? Example: I have a subform. If I select a record by clicking the record selector, then hit the delete button on my keyboard. I get a message that reads "You are about to delete 1 record. If you click yes ......."...

Hi everyone .. I can't figure out a way to accomplish this task. Hopefully someone can help me.. here goes: I have a form with 6 unbound checkboxes named (computer,laptop,blackberry) and 1 command button called "submit". This form is used to request the above mentioned technology...

Hi I hope someone can point me into the right direction. I'm trying to set up an ODBC connection to my Access database from a security application called CCURE. The CCURE applications resides on a Windows 2003 Server. MS Access isn't installed on the Windows 2003 Server. Does it have to be...

I have a query that runs based on selection from a form. My form has 2 fields [txtStart] and [txtEnd]. I want my query to return all records if those 2 fields are left null. But if the user enters a date into both I want the query to return records where the field [CompletedDate] is between...

I am simply trying to use the openDatabase method to connect to my database from MS Word. Then once I connect, use the objects in that database to manipulate some data. I don't know why my code it isn't working. I have searched and searched for answers but to no avail. Can someone please...

I have a table with a field called "RequestNames". The field type is set to hyperlink. When I open my table, I am able to click on a value in that field and it takes me to the destination. But here's my problem. I am using that table as my rowsource for my listbox but the values aren't...

I have a macro named "macEmails". This macro includes 10 macronames. I want to create a label with its hyperlink address pointing to the macronames. However it only allows you to select the actual macro object "macEmails" but not any of the macro names inside of the macro. How do I...

Hi guys.. I didn't have the reference to Microsoft Scripting Runtime .. thanks all.

Is there a way using VBA I can export a report with 3 sub reports to Word? Any ideas would be great. Thanks