Search results

I have a report that displays training completed for an employee. Some of these classes have expiration dates and others do not. The query that this is based on has fields that are DateCompleted- the date the training was completed, Expiration - the number of months that the training is good...

It has been a while since I worked in Access so I am definitely rusty!. I need to add a field to a query that takes a date field (CompletedDate) and adds the number of months listed in another field (Expiration). The original fields are in different tables but are combined within this query...

I am updating an existing database with a front and backend. I need to add a calculated field to an existing table in the backend. I have searched but can't find any info on how to do this. Anyone have any idea of how to accomplish this? As always, thanks Sue

My programmer wishes to be able to post to the forum. He has tried to sign up but has somehow gotten locked out. Every time he tries to log in he gets a yellow message telling that the account has not been confirmed. He clicks to get an email but it never comes. He has checked his spam folder...

We need to replicate an Access report we have in Microsoft Word. The report has a fixed, small image in the header and so we embedded it in the report (it is not in an external file). To put this image in the Word document the only way we’ve come up with is shown in the code below. Dim apWord...

I have created 2 reports one that needs to be exported as an excel file and the other report as a PDF file. I have the exports working correctly for each on a button except this saves the files with the name of the report. The client wants the name of the file to appear as one of the fields on...

I am using the following to add a column to an existing table. How do I make this column indexed with no duplicates? Thanks Sue

Can someone help me with this please. I have an existing database and need to add a primary key to one of the tables. I can't do this because there are one to many relationships from that table so I need to remove the existing relationships before I make the primary key and then put the...

I have a continuous form with a text field that says "Select". There are two other fields, one of which is Brand. When the Brand Combo box has nothing in it I want the text box to appear (instructing the user to select a Brand) But once the user selects a Brand and goes to the next records, I...

I have a client that is using a split database. I am working on an update to the program and need to transfer a table to the backend that has the correct structure and information included in it. My thoughts are to make a one time use program that transfers the table to the backend. I have...

I have five reason fields in my table and I would like combine them into one field on my report, with line breaks between so each reason starts on it's on line. Also if there is a blank record, I would like the report not to display a blank line. I have found ways to do this online for 2...

I need to find duplicates in one table based on 2 fields, Name and UPC (if there are 2 records with the same Name and same UPC but the GCode is blank) which I have been able to create a select query using the Query Wizard and have made it DISTINCT. I have then set up a query to find matching...

Can I create a table in the back end of my database using VBA in the front end? My client is using this system and I can't easily go to their location. I need to create a table on the back end and have it available in the front end applications. My thought is to create a front end only for...

I am giving the user the ability to import a table from excel and trying to cover all of the possibilities of import error with custom message boxes. I have most covered but have a tricky one. If the user imports a table that has records that are null I need to detect this (ie. if the user...

I have created code to import and excel file and create a table from that info. Now I need to confirm that the import has the correct Datatype of Number and Fieldsize of Double for one of the columns. Any thoughts on how to do this in vba? Thanks Sue

I have a code that needs to be run on click of every button on my switchboard. It checks to be sure that the user has made a selection in a subform on the switchboard that the entire database then works on. If there is no selection there are all kinds of errors. I have created the code as...

I have a database used for several product lines. Depending on the product line selected, I need to add an image to my report as the header for it. I need to store the images (there are only 3) in the database and cannot have an external link to them. Have been trying to figure out the best...

My table has a yes/no field and about 10 records. I have created a form for the user to select which of the records he wishes to use - the records are displayed in a continuous form with a check box for the yes/no field. The user is to select one record by checking the check box in the record...

I need to hide my subform on load or open of the main form but am experiencing some weird results. I have tried putting Me.SubForm.Form.Visible = False in both the on open and the on load of the main form and it works only if the tables on which the subform have records in them. If the tables...

Can someone please help me with the code for VBA to set the child/parent properties for a sub form from the main? I have been able to set the record source, but can't find the correct vba term for the child/parent properties. I know this is basic stuff from many of you, but I have searched and...