Search results for query: *

I have created a small database in Access 2013 with several web forms that are shared through a SharePoint site. I have a continuous form with a dropdown box in the header which acts as a filter to allow the user to filter the records. The AfterUpdate macro uses the following code: SetFilter...

You need to make sure you use a DateDiff parameter to count Monday as the first day of the week. The correct formula should actually look like this: =(DateDiff("d",[start date],[end date],2))-((DateDiff("w",[start date],[end date],2))*2) As Traingamer states this will not account for...

I currently have a small MS Access application that allows the users to import data from text files, run reports or other functions on the data, and then export the data back to a text file for archiving purposes. However I am running into problems when the user tries to export a large table...

Great! That worked. Pink star for you.

I have a routine set up that allows the user to browse for a local text file and then click a button to import the selected file into Access. This works great for delimited text files but I need to also allow the users to import fixed width flat files. I cannot setup a Specification file since...

That worked great (first approach). Thanks a lot.

I am currently using a form in Access (Office '03) to allow the user to import data from various Excel files. This is done using the TransferSpreadsheet method. However, after the data has been migrated an instance of Excel remains open. This becomes problematic when the user tries to use...

I have had a similar problem in the past. To fix it I get the index of the selected record, refresh the screen, then reset the focus back to that record. Something like this; intTrace = (Me.Form.CurrentRecord) Call Form_Load DoCmd.GoToRecord , , acGoTo, intTrace hope this helps!

I'm not sure how you're going about this. I typically use the TransferSpreadsheet method. Syntax looks like this: DoCmd.TransferSpreadsheet acExport, 8(Excel version), Query Name, Spreadsheet Path, Has field names? (boolean) I use this method quite a bit and have never had a problem. One...

This worked great, Thanks!

The .value property is referring to the information that has been entered into the text box(if any). It is not a boolean operator and does mean that your text box actually has a value. If you are just trying to make sure that the text box is not blank you can try something like this; If (Not...

Have you tried plugging your IF statement into the ControlSource of the text box? You should just be able to use the = sign plus your IIF statement.

I am using an ActiveX DTPicker control to allow the user to add new dates to the database. However, when the screen opens I want the date fields to be blank so that the user is forced to select a date. The problem is I have not been able to find a way for the DtPicker to display a null value...

Wow, I can't explain why but that worked great. Thanks a lot.

Thanks for your reply. I tried your suggestion but I am still seeing an instance of Excel in the Processes list after the code has executed. I use this same kind of logic to interface with Word and Outlook and it works fine. I'm stumped! I do have an Exit Sub statement before my error handler...

I am using VBA code in Access 2000 to import a user-defined spreadsheet into the database. This is working great except the Excel instance does not close. When the user then tries to move or delete that Excel file they receive a message that the file is still in use. Currently the only way...

In response to your second question; Try handling this from the section format event. It would look something like this.. Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page = 1 Then me.Name.Visible = True Else Me.Name.Visible = False End IF I as...

I'm not sure how you would go about assigning pictures to a report but I have some code that will dynamically list all .jpg files in a given directory and list them in a list box control.... Dim MyFile, MyPath, MyName Dim Source As String ' Display the names of the pictures in the list box...

Place the fields in the details section; TotalMeth TotalTake Then in the Report Footer or Page Footer add a text box control with a control source something like this; =((Sum([TotalMeth])) - (Sum([TotalTake]))) This should give you your available inventory.

I've run into this problem myself. The issue is that the OnFormat event only runs once when the page is formated and not for each item in your details section. You should try and use the Conditional Formatting to hide the field if it is null. This will evaluate every instance in the details...