Search results

Unique Problem here and I am all out of answers so any help would be appreciated. I have to create an extract to an Enterprise System that relates date differently than what I am used to in Access. Basically, I have to extract a Parent and Child (one to Many) Table out of Access where(and here...

Unique Problem here and I am all out of answers so any help would be appreciated. I have to create an extract to an Enterprise System that relates date differently than what I am used to in Access. Basically, I have to extract a Parent and Child (one to Many) Table out of Access where(and here...

Is there any way to automate the export of an object from Access in XML Format? Is XML Supported in SendObject? tHanks in advance for your help

I have a fairly unique problem, I need to create an extract from Access to update an enterprise system. The format must be text, similar to the following format: 10ASTAR LOGISTICS TOM LEE 111.866.9876543 Where this would be one record. "10" is a field, "A" is a...

Question: When you use SendObject to send an email through outlook, does the email sent use the Read Receipts property if it is set to yes in Outlook? From what I can tell, it does not. Users that have read receipts on their personal emails do not receive them when sending an auto email from...

I have to make a form that extracts out to multiple buyers for our company. What I have been doing in the past is making the form based off of a table with a record for each buyer along with the email address. There would be a button for each record and the user would click on the button...

I want to be able to export a query from Access via a button on a form. I know how to use the transfer... to do it but I want it to run exactly the same for the user as if he or she had selected Export from the File Menu -e.g. the user is prompted for the save location Does anyone know the...

I have made a simple updateable form based from one table. When I set the form to dynaset or dynaset(inconsistent updates) and get back into the form, the form only allows the addition of new records, despite the fact that Data entry is turned off. When I set it to snapshot, it shows all...

I'm automating my database and using a transfer text module in the macros to export CSV files. Everything is great except that, in the CSV files, the date adds the time at the end automatically. I am running these transfer text modules to export both queries and tables. The format for both the...

I have an SQL table with 19000 records. everything running off of this table is very slow. If I go to the table and try to Control F find the last record using a clustered index field, the search takes about 45 seconds. Is this normal? the weird thing is that If I were to create a query and type...

Is it possible to run VBA code within a macro? What i want to do is run one macro for certain days of the week and another macro for other days of the week. I could just stick the code in the button on the switchboard but I could see an overzealous user changing the switchboard and then the code...

I want to set the "Fee" Field on a form to the penalty value in the Penalty table where Penalty = "Non-Compliant Docs" This is what I came up with but it keeps telling me there is an error in the From clause. This is my first time using SQL on Forms. Any glaring flaws. Would this even work...

I get an excel report from outside the company that contains a text field that can have a range of values but all we want to import is the letter code before the / sign. The field may be CFS or CFS/CY or CY/CY/CY or anything but all we would want to import in each case is the data before the...

I recently added a bit field to an SQL table. The table already had bit fields in it before that worked properly. I added a new one. In access, when I run a query on it, no records are returned when I enter anything as a criterion. True, False, o, 1...doesn't matter. when I leave the criterion...

I am trying to adopt a consistent naming scheme for my forms. When I try to change the name on a subform, the mainform no longer dsiplays it and I can't find an easy fixt to change the name. Does anyone know? thanks.

okay, -First, I am on a SQL Server. I have a form whereby the user can click on a form and a pop up form will be displayed for that record. The user can make a selection on the pop up form that will run an update query on the table underlying the mainform. And, indeed, this is what happens the...

Hi, I have a form that is maximized on the Load event. On this form, I have a button that opens a form based on a query which is in turn based from data entered on the main form. My problem is this: I want the secondary form to be a smaller size when it is opened. I have set the size on the...

does somebody know of a good tutorial on conditional statments in VBA? Some times I write them and they work. Other times, they just run as though the condition is always true, no matter if it is or not. Does anyone know of a good tutorial or can provide me with a "lighbulb" reason for why the...

Okay, I have a conditional statment that works, but runs through the "Then" and "Else" cases no matter what Me.Check_Field equals. I get the Msg Box no matter what. I'm probably doing something incorrectly, but I've done conditional statments this way in the past and they worked. I have pasted...

Okay, here goes: This is a Puchase order change request form whereby the User can change select a PO and change marka new date for the PO. This gets recorded to a table called PO change request. The PO can be changed multiple times before it is shipped. Each individaul request is copied and kept...