Search results

I have been very lax in building error trapping into my DB applications and am now working on one that requires it. Can I put this into a function and call it whenever I have an error anywhere in the form? If so what is the best way to do it? I have a basic idea of how to call functions am...

Hmmmm you are not getting an error or anything? Just non action? Does the system become unstable at all? Post your code so I can peer at it again. It has been I while since I first worked on this with you and I must of deleted the demo code I tried out.

I am working on a way to hold a variable throughout the life of an application. I created a module like this: Option Compare Database Option Explicit Public strUname As String Public strPword As String Public intAccess As Integer The idea is to use a login form with a user name and password...

Slyvia you should be able to accomplish what you want. I was in the exact same postition as you are a while back and was able to overcome it first by using an update query and then later by using a query on top of my table, altering the format from there and then exporting the query to a CSV...

silvia, The input mask does not actualy change how the data is set in the table. All it does is affect how it is shown in a form or a report. You should be able to change the properties of the field in the table to get it in the format that you want or if you are using a query you could edit...

Did we lose ya?

Oops I missed this from your previous post: Put semicolans at the end of each name that you send to the distribution list and then use the distribution list as your source for the email addresses. DoCmd.SendObject , , , Me.DistubutionTextBox, , , _ "Optional Subject Here"...

David R, Thank You for clarifing that point! Treas, Ok so how are you selecting the people? You could do it from a listbox, using checkboxes or multiple comboboxes. Clarify that point for me and I think I can help you wrap this up.

Treas, Talismanic wishes he knew half of what I know about sending emails from Access. Notice he does not post here anymore. This is because when I joined the forum and started posting he stepped aside and went into hiding. I think you find your answer in this thread: Topic: Send a single...

I think I have managed to get around this problem but would still appreciate any input as to why this might of happened. All I did was restore yesterdays back up with a new name and then just imported only the two tables that have been updated since the back up was done.

One of my databases stoped working today, when ever a form is opened I get a this error: Error Number 3197: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. That KB article or one of the articles I...

I think this covers it all: Topic: Count files in a dir Topic: List files on subdirectories Topic: How do I Delete a Directory Topic: Browse drive for files Topic: Moving files in code Check the Moving Files in Code and the How do I Delete a Directory specificaly for your question. To make a...

Ok maybe I am confused then. Is deleting the spreadsheet an option? If so you could use the shell command to delete the spredsheet before the thansfer is done.

Insert a line in your macro and set the Warnings to false then right after the transfer make sure you turn them back on. Unfortunately this graphic doesn't show the command in th bottom there but if it did it would say Set Warnings > No and then Set Warnings > Yes. HTH

Rhubbard this should get you started: Topic: how do i make a report to just show between two dates Topic: I want to filter my report by specific dates Post back if you have more questions.

Amy35 try this thread. I think it may contain an answer to your post. Topic: Network User Name There is also a function that allows you to grab the computers name here. Topic: Interrogating the LDB. HTH Post back if you have more questions. [This message has been edited by BukHix (edited...

I am not sure of the best way to trigger the event but your macro would look similar to this: If you wanted to do it with code instead of a macro you would so it something like this: DoCmd.SetWarnings False DoCmd.OutputTo acReport, "VehicleReport", "RichTextFormat(*.rtf)", _...

There are a couple of different ways that you could manage this. If you just want to have access put the files in a directory for you this will work. DoCmd.OutputTo acReport, "ReportName", "RichTextFormat(*.rtf)", _ "c:\Inetpub\wwwroot\FileName", False You can also use the Shell command...

Oops I forgot to unrem the line with the format change. I was still using the two m's insead of the three. Here is what it looks like: Dim dtDate2 As String dtDate2 = Format(Date, "mmm") DoCmd.OpenReport "repEmpUpdates", acViewPreview, , _ "[Month] = '" & dtDate2 & "'" [This message...

Thanks it worked but I have one more question. The code returns the months number which is ok but can I convert it to a name? So instead of 3 I would get March.