Follow-Up To Previous Post...
Nov 15, 2004
Greetings,
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.
View Replies
ADVERTISEMENT
Nov 16, 2005
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!
View 1 Replies
View Related
Jan 22, 2007
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?
View 1 Replies
View Related
Mar 4, 2005
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
View 3 Replies
View Related
Jul 15, 2005
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.
View 2 Replies
View Related
Mar 14, 2006
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.
View 2 Replies
View Related
Apr 10, 2006
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?
View 1 Replies
View Related
Feb 29, 2008
Hi,
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?
Criteria: >="2000"
View 8 Replies
View Related
Jun 23, 2013
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
View 3 Replies
View Related
Jun 3, 2005
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 am using Access2000 on an XP machine. . .
View 7 Replies
View Related
Aug 6, 2015
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
[Code] ....
View 2 Replies
View Related
Sep 9, 2013
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
View 11 Replies
View Related
May 6, 2005
I have a very involved question regarding the export of data from and Access front end, SQL back end into multiple Excel Worksheets.
Where is the best place to post this in order to get maximum exposure to the great minds that cruise this board.
Regards
View 2 Replies
View Related
May 17, 2005
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!
View 1 Replies
View Related
May 24, 2005
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
means for 25 hours is shows 1
Please help me to overcome this problem
Thanks
Pehalwan
View 5 Replies
View Related
Jul 8, 2006
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.
View 1 Replies
View Related
Sep 4, 2007
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.
Any ideas on how to solve this problem?
View 2 Replies
View Related
Mar 17, 2005
could anyone please tell me how to post a database on this forum ive tried attachingit but it says file not suitable
View 4 Replies
View Related
Nov 10, 2005
i need dbase example from all of u..especially example for newbie like me...i'm looking for example that update subform using combobox...
View 5 Replies
View Related
Aug 16, 2005
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
View 2 Replies
View Related
Nov 29, 2006
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
View 2 Replies
View Related
Mar 15, 2007
Hi guys am not sure if i got dis in d correct forum (forgive me if not)
Just wanted 2 know what's d diff btwn a thread & a post (if d's any)
Noks
View 6 Replies
View Related
Jan 23, 2008
Hallo,
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 ....
Many thanks
View 1 Replies
View Related
Apr 7, 2006
I have searched the forum for posts on the subject of UK postal code validation and found the reg expression that seems to be recommended for this.
I tried the expression but it will not accept this postal code? TS183AM
Like "(?:(?:A[BL]|B[ABDHLNRST]?|" & "C[ABFHMORTVW]|D[ADEGHLNTY]|E[CHNX]?|F[KY]|G[LUY]?|" & "H[ADGPRSUX]|I[GMPV]|JE|K[ATWY]|L[ADELNSU]?|M[EKL]?|" & "N[EGNPRW]?|O[LX]|P[AEHLOR]|R[GHM]|S[AEGKLMNOPRSTWY]?|" & "T[ADFNQRSW]|UB|W[ACDFNRSV]?|YO|ZE)" & "d(?:d|[A-Z])? d[A-Z]{2})"
View 14 Replies
View Related
May 23, 2007
Hi,
I'm trying to isolate the first letter / letters of UK post codes.
Typically they are of the format ..
WS9 0JL
The obvious choice is left,2 but of course it's never that simple
some post codes are B1 7FH so left 2 gives me B1 but I need just the B
I can use Left 2 and the look at the second character to see if it is = "1" or "2" etc. but this seems a bit crude.
Is there a way I can find the position of the first number in a string (using the Instr function maybe)
That way i could Isolate the letter/s
Thanks
SBM
View 2 Replies
View Related
Jan 4, 2007
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.
I've included a typical example.
View 1 Replies
View Related
