I am just posting a follow-up on my previous post on designing functional forms. Telling by the lack of replies, my original question may have been long winded and tedious. Let me try to narrow my question and make it more concise.
In two tables connected by a one-one field name ProfileID, how can I set a new field in the second table (call it StepNo or procedureNo) so that it increments step numbers for each unique ProfileID record? Thus for each new Profile record created in the first table, a new form will allow the entry of X numbers of steps into the second table and automatically link the two records?
I hope that clarifies my problem. Thanks in advance.
I sent a post earlier today about making a label visible in a subform! I am still working on it but still no progress!
I have a different scenario (its the same thing but trying to explain the method i'm working on):
I have one main form (frmMain) that contains 3 subforms, say subfrm1, subfrm2 and subfrm3. On Open only 1 is visible and 2 and 3 are invisible (however they are open and loaded).
By choosing an option on 1 subfrm2 becomes available! When choosing an option on subfrm1 a boolean called 'XXX' is set to true. Now i want one particular label to become visible in subfrm2 if 'XXX' is true! To do this i need to write a code to be executed when subfrm2 is appears on screen! The problem is this form is already open so how and on which event of subfrm2 can i write the code???
At the moment i'm trying to refresh subfrm2 (by using code in subfrm1) and I have placed my code on the On Load event of subfrm2. I thought this way the form will reload and the On Loand event will pick up the new value for boolean XXX and set the label to visible! Thats the idea anyway... here is the code i have in subfrm1:
XXX = True
Forms![frmMain].subfrm2.Form.Refresh
subfrm1.Visible = False
subfrm2.Visible = True
I'm not sure if refreshing the subform will result in On Load event to be executed! And i'm not even sure that the code for refreshing subfrm2 is correct. Can any1 help me with this?
I have attached the actual database on my previous post sent today, if you prefer to look at the whole thing and get a feel of the problem!
What steps do you(s) follow or recommend to creating tables? Any standard questions? I was reading Erwin, data modeling book and didn't see a stardard check list of things to ask.
I think I need to set the following up in a db, (currently in an excel spreadsheet - has a lot of Redundancy in it) type of inspection checksheet, by machine (20 machines) and shifts (3) There are 20 or so questions that need to be filled in, (yes/no and numbers). any thoughts?
The fields on my form are not in the same order as in the table. When putting new data in the form and moving from field to field by TAB key, the cursor would jump from the field to field in the order of fields in the table. How do I change it so the cursor moves from field to field in the forms format. Thanks in advance, John
thanx for the advice...that does make more sense. my only other issue is adding the letter (m for meter permit, h for hydrant, etc.) to the permit # if they are all going to be in one table. btw, sorry for the duplicate postings...just under a bit of stress @ work. i'll make a note of it.
How do I enter a formula/calculation in a table for follow up dates. I have a basic start date. In my form/table, I want the program to insert the following follow up dates automatically: one month, 3 month and 6 month.
Does anyone know how to go about this or know previous thread stating how to go about this?I have a Follow-Up labeled Text Box (Short Date) and I want for the associate to be able to set a desired follow-up date and for the account to disappear from the list afterwards till the follow-up date expires and it becomes viewable again.Any suggestions?
I'm wondering why my query is not working properly. All I'm just trying to do is to display all the years greater than or equal to 2000. But still, it displays the entire content of the colum from 1991 to present. How did this happen?...
is there something wrong with the way i set my criteria?
I am trying to use followhyperlink as a way to open a link in a browser to a file in a shared dropbox folder. I have a form with a control, the control is named LinkToDoc it's record source is a text field in a table. The file path in the table is similar to [URL] ..... I am getting run time error 15, cannot open the specified file.
Code: Private Sub cmdOpenFile_Click() Application.FollowHyperlink LinktoDoc End Sub
I am a completely green when it comes to Access and MVB. I've surprised myself in creating the db and form.
My db is for troubleshooting outlet issues. I have a list of outlets and their various configurations. Users NEVER add or change any info. They select the outlet from a combo box and view the information. The problem is that you can move the wheel and change the outlet information being displayed but the combo box does not reflect the change; it continues to show the initially selected outlet name.
How do you get the combo box text to follow the mouse wheel?
I thought an easier solution would be to disable the mouse wheel, but in looking through this forum, apparently not.
I follow a ritual of moving last to first before looping through a recordset. I started following this because in the way back (I think on office 2003). I used to get an error if don't do it. Is the problem still exists? Is this ritual scientific still?
Code: Sub mac() Dim myRset As Recordset2 Dim AttachmentField As Field2 Set myRset = CurrentDb.OpenRecordset("Table1") With myRset .MoveLast
I am trying to create some code for a button in a report that will follow a hyperlink to a specific file. The problem I'm having is that the files that are at the end of the hyperlink can have various extensions (*.doc, *.docx, *.pdf, etc.) I'd like to be able to put a wildcard in the code to allow the opening of the file regardless of the extension.
Code so far:
Private Sub Command6_Click() Application.FollowHyperlink ("C:UsersjbeggDocumentsAccessTestFolder" & [FileName] & ".*") End Sub
I have a form that has several multiple choice question and i have also designed a table and update queries for the DB so far i can enter the values and then have them changed from the original to the values requested by my bos however i also need to find a way to make a report that will allow me to shot the percentage of people that chose each individual answer with anywhere from 2 to 10 possible choices on each question i see no logical way to do this....... help!
Hello every one I am new here and this is my first post I am trying to make overtime record for my company I use the following feilds
field name .................... format Start_Time ................... short time End_Time ..................... short time Total_Over_Time ........... short time
now when i use Total_Over_Time = [End_Time]-[Start_Time] I got correct answer
but
while i am trying to make monthly report if Total_Over_Time is greater then 24 hours it shows me 1
I am developing an Access (2000) database to provide reporting data gathered from SAP and make it easily accessable for 12 analysts. The data set is HUGE, 5 months nearly a gig and will need at least 2 years worth, so I don't see any option other than using SQL as a back end. I have experiance using SQL server as the back end but have never had to develop my own server.
I do not have access to an existing server but do have permission to purchase SQL software, this is where I need the help. If anyone has suggestions, advice, links or other information I would be greatly appreciative.
Thanks in advance for your help.
“where I added information”
A lot of you have been reading this but no help.:eek: Did I use a poor title? I have used SQL as a back end but really need to know how to produce one out of thin air.
I ordered SQL 2005 off my company's IT store but when reading further it needs a special operating system, I think. Is this true? What do I need to have in order to provide a very large data set to a bunch of barely computer literate analysts?
These people are excited when they realize that vlookup can do more than one thing!! The concept of a union query would blow them away. I am frustrated with the competency of my co-workers but need to give them something that is idiot proof without letting them know that this is the object.
Currently they are having an SAP download sent to a specified share drive and running an Excel “macro”, moves a couple of columns an such, that puts it into a format that is semi-usable. This is totally inefficient for their needs but they don’t know it as yet.
What I am asking is how to take a fairly robust pc and make it a SQL server that will service a dozen or so people. What kind of operating system is needed and what sort of admin rights will be necessary to allow access to the desktop so they can get their data?
The IT help desk is very scary, not really understanding the requests presented. I haven’t been with the company very long but what I have garnered disturbs me I don’t believe the IT people have a clue.
I’ve been an Access developer for about 4 years now and know this is not an insurmountable obstacle. I am confident that SQL is the solution but haven’t ever had to create it from scratch before. Please, links or other suggestions are MOST appreciated.
Preface: I don't know where to post this since I'm using a VBA executed SQL command or if this is a table issue.
I'm trying to import a .csv file into a "master" table of several .csv files. I've figured out how to link them and import them even though they have different field names, but the problem I'm running into is with serial numbers.
Some serial numbers are entirely numbers, while others are alphanumeric. When the field is set to numbers all of the parts (a different field) show up, but not all of the serial numbers are imported. When the field is set to text some of the parts are dropped, along with their associated serial numbers and then some of the serial numbers show up as scientific notation.
does anyone know if it is possible to add a post code checker/search to access, if so do you know of one which works. I want to be able to bring up an addess by post code/house number in the UK
HiBeen trying To Find A Way Of Validating A Postcode.But Getting No Where Being They Can Be Like CT1 1QX, CT11 2DT, CT11 12DT Act.Best I've done is to make sure there's a space and it starts and ends with a Letter.Any Help Advice Would be much AppreciatedMick
I have a post code field on my form. What I want to do is, if a user enters a wrong code ... i,.e., not Post code format it alerts the user of post-code not in use. Please if there is any example of a database of this functionality usage or a way of doing it will be much appreciated.
I live in UK and the post codes down here are like E12 5AH ....
One thing that I personally think I'm bad doing is creating GUIs. I think my forms look pretty bad overall, and I'd like to get some ideas/pointers from some of the more experienced folks.
