I have something that is really taken up too much time and also given me a headache...
I have a subform related to a main form....cool no problems there. I am using a couple of fields from the main form within the subform and adding dates, names and contact details to associate with the relevent records.
Can this subform facilitate the autocomplete phenomina that i see in windows and excell and the like so i dont have to continually type the same names.
I tried to select names from a combo box but it got messy and names were being overwritten by numbers and i nearly broke my screen...lol
Wanting to get functionality back in to this app at the moment, and suggestions are eagerly sought:confused:
First post :) found some great tips on here. Anyway here is my story and question.
I am new to Access development. I know what I want to do, I just can not find a way of doing it :( .
1) I would like my form to only be editable when an edit button is clicked. I am not sure if I can do this on a form level or if I have to change each individual part. Any ideas?
2) I capture some clients details, title, first name and last name. I then need to merge the above 3 fields into one to create a 'policies in the name of' field. Is this posisble? I have tried using the initial value expression but am having no luck. Any ideas?
Ok... big time newbie/hack here. I have a tiny bit of programming experience from waaay back with UNIX and C. Have basic database experience and understanding but no VB experience. So I appologize ahead of time if this seems really simple. I'm working on "fixing" a small access database/program for my wife's work. Very simple design.
I have a company table and a customer table. I have customer form and a company form. They may have several customers at the same company. So my design has them starting on the Customer form. They begin by filling in the Customer's Name and then they get to the Company Name combo box. They should select the Company Name from this box. If it is a new company and is not in the list they should click on the "New Company" button beside the Company Name field. Then the Company Form opens and they can add a new Company along with Company address and phone numbers etc. Then they close the Add Company Form and then can select the newly added Company form the Company Name combo box (by the way, the only way I could get this box to update with the new company name was to use a macro that only runs the Requery statement for the On Enter event... it works... I hope this is ok).
Anyway, this is where my problem arises. I need the selection of the Company Name to also pull over the address, phone number, fax number, etc. info from the Company table and complete it on the Customer form/table now. How do I do that? I think I need to do this with the After Update event with some VB code... but I have no idea how to actually pass this data. The property for my combo box is as follows: Control Source........CompanyName Row/Source Type.....Table/Query Row Source......SELECT zMASCompanies.CompanyName FROM zMASCompanies;
The field doesn't have to be a combo box (if this is not the right way to do it)... I just need them to select a company name and have it fill in about 20 or 25 fields from the company table/form into the customer table/form.
I did try searching the forum and found a few things but nothing I found was very clear (especially since I am not sure I am even heading down the right path). Any assistance would be greatly appreciated!!!
I'm on my way on creating a simple Database for a company. This database contains several tables, one of the tables will record information about the training that had been completed by each employee. There are about ten sections of training that should be completed.
For instance, I have two tables called 'Development' and 'CSA_Lisence'. 'Development' is the table that record the information about training which containing ten checkboxes (which represent ten sections of training) and CSA_Lisence will be automatically requeried when all of the checkboxes on Development are fully checked.
Here's the step I've been worked on :
First, I made a function called 'CheckCompletion' to ensure whether all the checkboxes are checked :
Code: Public Function CheckCompletion() As Boolean Dim blnComplete As Boolean Dim strCompletionSummary As String strCompletionSummary = Basic_Inspection & Certifying_Staff & Safety_Management_System & Regulation_Part_145 & Part_M & EWIS & Fuel_Tank_Safety_Level_2 & Dangerous_Goods & Human_Factor & Basic_Supervisory_Training
[Code] ....
Second, I made a function called 'UpdateEmployee' to handles if all boxes are checked :
Code: Public Function UpdateEmployee() Dim emp_numb As Long Dim emp_name As Long Dim strsql As String emp_numb = [Forms]![development].[employee_number].Value
[Code] ....
Then, I put this code on every checkbox's after update event (example only) :
Code: Private Sub Basic_Inspection_AfterUpdate() Call UpdateEmployee End Sub
The problem is, nothing happened with the tables. However, when I managed to remove the 'If checkCompletion' condition, it worked and the 'CSA_Lisence' is requeried, but I will have ten multiple records with same contents (I just need one record per employee). I guess there's something wrong or missed in my code. Or i need to remove something?
I'm trying to make it a little further with my new call answering database at work.
Basically it consists of a main form that has a button leading to a call answering form for each business that we represent. it also has a text box that displays the number of the caller when the telephone picks up, the correct call answering screen is also popped by the telephone software and a macro whenever the phone is answered.
I've got code in place that automatically puts the date and time in the correct field and also copy the incoming telephone number from the main form into the caller number field on the call answering form.
I'd like to take this automation a little further now and get the form to autopopulate the caller details if that caller has called before (we get a lot of calls from the same people) so i'd like to make the form search the table it's linked to for the incoming phone number and to fill in the name, email, company etc... for the caller according to the previous record.
The code for the 2 forms i've currently got setup (the switchboard and one call answering screen) are as follows
Switchboard:-
Code: Option Compare Database Dim WithEvents MaxxCom As Metro_MaxxCom_CTI_COM_API.CTI Private Sub cmd_onnet_Click() DoCmd.OpenForm FormName:="On_Net_Communications" End Sub
we use access database for printing lab reports. and a small graph is also printed on this report from another software(not an access application).
what i have done is that first we print the txt report from access and then use the same paper to print graph on it. I have alligned the report in such a way that these two reports fit perfectly.
we have to print twice and sometimes the graph is deleted in the other application, so we have to make the graph again.
what i want to do is: 1) prepare graph in the other application. 2) take a screenshot of it. 3) save this as an image file (jpg or bmp) 4) reference this picture in the access application and print it with the report.
So the problems are: 1) when i take a screenshot, how do i save it as a file, 2) how do i just get the area of the graph and remove all extra space. (usually all the other space is white as background)
Hi all! I was wondering if you guys can help me out with this one:
I would like to have data auto-inserted from a particular colum in table 'x' in to a defined column in table 'y'. similary, I'd like to achieve auto-updation of this data as well as deletion. Can anyone please provide some guidelines?
A little more detail :
I have a column "Client ID" in the table client_personal_info, the rows of which I'd like to have updated in the "Client ID" column in the client_business_detail table.
So if say, ClientID_1 is a row that has been added by the user, I'd like to have it auto-inserted in the client ID column in the client_business_detail table
Access 2010 keeps changing the Capitalization of objects when I don't want it to.
For example "Cancel" becomes "cancel". Later it will be changed back to "Cancel".
There is also a table with a field "FULLNAME". Several Queries build a field "FullName". As a result FullName, even in places like Application. CodeProject.FullName get changed to Application.CodeProject.FULLNAME.
(Track Name AutoCorrect is off. ) It is especially irritating because I export the code to text files and check it into source control. Sometimes dozens, or even hundreds, of files will show up as changed because Access did it's rename thing.
Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.
I am sure I’m not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question.
I've tried googling this, but I can't find anything helpful. I have five columns in my 'Main' table. In each row, column B, C & D are solely dependant on column A. And column E is completely independant of all of them. I want to be able to select a choice in column A using a drop-down menu (which I know how to do) and have columns B, C, & D automatically fill themselves in (which I don't know how to do). Column E I would just manually enter.
How do I get columns B, C, & D to automatically fill themselves in my 'Main' table. I would select a value from a drop-down menu in column A and want everything else to fill in. The values for A,B,C,& D are all in seperate tables with an ID and linked to their respective fields in the 'Main' table. Appreciate any help.
Hi all, Is it possible to have different colour fonts in forms automatically?
i want the user to add numerical data into the form but the middle numbers must automatically be coloured red. these numbers are then matched to stickers in the same format for easy identification.
If am a developing the db and just making alterations to forms and reports etc on a developing copy. Is there anyway i can auto pull and replace the ones in the live db rather than going into the live db, deleting all the forms etc and then importing it?? can it be scripted or somethign like that?
I make a data base every year for work orders that my work does for our customers, I have every thing set up and it looks great except for one field, last year I was able to make it do an auto number once I put the date in. for example first box work Order # ___ second box date once I put in the date an work order # would fill in the w/o# box and it would follow what ever the last work order # was (12600). for example I need the year 2006 TO START OFF WITH # 12601, What querie/option do I need to accomplish with this info.
Hi...Im working with this database..its an order tracking database.. everytime we received the shipments we have to update the rcvd items.. i have an attachment here... pls i really need help...
How could i do these automated:
1: if i update the Rcvd status (Y/N) "Y" ...how could i make the Date Rcvd automated.. coz what happens is that.. i have to put date in each items that we rcvd and its a waste of time.. what if.. i have lots of rcvd items..
2. how could i put row count.. so i could know how many items i have and on what row are they...
I have a table already set up in a Subform of a main form
The Table has values like -Date -Time -Name -SchBy
I want to have the subforms table to automatically re-sort ascending by Time, how would I go about doing this so the user doesn't have to click the field then sort ascending button...?:confused:
I was thinking of an idea to backup the database in a multiuser (FE/BE) environment, without disturbing the users. Please comment on it as if it has any drawbacks.
And also soemeone please help me do this, if its does not contain drawbacks.
************************************************** ******** Main Idea
What I want is to automate backup process at fixed intervals, in a FE/BE environment without disturbing the users i.e without disconecting the users. And I think it is possiblke and safe to do if we start the backup process when all users are inactive and stop any user activity or stop Frontend's interaction to the Backend, while in the backup process.
And If no such time is available as all users are inactive within a certian time then forcefully stop user interaction to the backend and start backup process.
To stop user interaction with the backend , we can close all objects (forms, reports, queries etc) and open an unbounded modal pop-up form , with no close exit button. This form can have timer and after 30 seconds or maybe 1 minute we can auto close this form so that the user can again use the application. We can stop new logons by placing an ini file in the folder where the Backend rsides. This Ini file can contain two keys ( "lock time" and "lock status"). At the frontend startup we can query these value from the inifile to check that new logons are allowed or not, and if the "lock time" is greater than 2 minute then bypass the lock status and allow new logons. It means that something went wrong with the last backup process and the ini file was not updated to new lock status. We can have a table or an in file store the normal and maximum time at which the backup process starts. These values can be queried and compared with the current time using a hidden form. If the normal time exeeds the current time then start looking for a state where all logged on users are inactive (i.e all objects are closed in the front end of all users). If such a state is found then warn the user that backup is going to start in 1 minute, lock new logons, after 1 minute close all open objects and then bring up a modal form that i have described in step 1 and start bakup process. And if no state is fount till the maximun time then warn all users that backup would start in 1 minute, lock new logons, after 1 minute close all open objects and then bring up a modal form that i have described in step 1 and start bakup process After the backup is complete set allow new logons in the inifile.
Why is it that auto center doesn't auto centre? Yes it centres horizontally - but not vertically. Does anyone know how to actually center horizontally and vertically i.e centre!? (I have used both spellings in order to appeal to a larger audience!)
Can someone please look at this and help me as it does not work? It stops right away at the "Dim olApp As Outlook.Application". It tells me "user-defined type not defined". I have searched the forums and could not find a solution.
Thanks, RichB
Private Sub Command154_Click() Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application
'Create e-mail item Set objMail = olApp.CreateItem(olMailItem) With objMail 'Set body format to HTML .To = "Forms!FrmPersonal!Email" .BCC = Forms!FrmPersonal!rateremail & Forms!FrmPersonal!rrateremail .Subject = "AUTO EMAIL REMINDER" .BodyFormat = olFormatHTML .HTMLBody = "<HTML><BODY>Blah, Blah, Blah</BODY></HTML>" .Display End With
Hello I am going to be developing a site that will need to give qoutes.
So person will fill out a form and when they send the form. They will receive the exact about of money it will cost them
So I fill out a form asking how much will such and such cost, I send it in With in 2 or 3 minutes I receive an email with the exact amount of the cost.
Can this be done with access database..If so or how would I approach this situations. Remember this is an auto response with the exact answer I was looking for from the form I filled out.
Hi, I have created a database in access to build an inventory. The structure is very similar to the "Home Contents Inventory" template from microsoft.
I want now to generate auto-labels for all contents in the inventory in the format XXX-XX-999 (XXX=Room, XX=Device, 999=number of devices in room) so for example if I have three PC's in the OfficeSpace room the label should be OFS-PC-003
I have created fixed value columns for Room and Device with the abbreviations stored all I need now is to somehow concatenate these two columns and assign an autoUpdate number so that the Label remains unique throughout (OSF-PC-001, OSF-PC-002, PSF-PC-003, BOR-PC-001 etcetc)
I have a form with four subforms which display highest scores in four categories during a competition. At the moment I have to manually refresh the form to see the latest scores. How can I get this to happen automatically say every 2 minutes? Thanks Dennis
I am using the Auto FE Updater to update the FE's of my database over a LAN. The utility is setup and working normally for the most part, but I have one little issue that I can't seem to find any info on anywhere.
There are two groups of users that are only separated administratively (not geographically), they are in the same building. One set has their drive containing the database FE & BE mapped by a logon script; the other group must map the drive manually. The problem is with the second group; they can't map the drive to the same drive letter because they have another drive automatically mapped to that letter in their logon script. Plus since they are doing their own mapping, they don't map to the same letter amongst themselves. I am using a shortcut to the StartMDB.exe on the network drive (the shortcut is in a separate folder from the actual executable). I am using UNC everywhere possible but when the shortcut is put on the desktops of the second group it still points to the drive letter of the first group. If I try to change the shortcut to UNC it always reverts back to the letter it is mapped to.
I am trying to make a .cmd file so I can use UNC there but can't get it to work. Does anyone have a .cmd file that starts an exe and points to an ini file as would be needed by Auto FE Updater? If so could you post a copy of it so I can see what I am doing wrong? Also, does anyone have any other suggestions?
Does anyone know if it is possible to create a macro (or whether there is another function) so that a database will automatically close after a period of inactivity.
There is only one form that users will see (or use) but if this form remains inactive for say 20-minutes the program shuts itself down.
My initial thought was to use Form>On Timer facility but I would need to be reset the timer after every update. This seems particularly longwinded and I'm not 100% sure it would work.