Hi
I am new to VB.
Can anyone tell me what the 'ac' part of a method, such as 'acReport', actually means. I am guseeing it may be something like Active Command or similar.
There is no other reason that curiosity for me wanting to know this...or is there??
Thanks in advance
Danny,
Below is a outline of the new application that I would like you to write.
In a nutshell, this application will test the connectivity to specific network dirves/directory and display whether the connectivity test passed or failed. I see this as something that automatically runs once started then displays the results. Understanding "error" handling will be an important part of this.
Test cases to include:
a) Tag Inventory System = W:Company Shared DataTagInv
b) Maintenance Stores System = W:Company Shared DataEngineeringMtceStores
c) Customer Information System = Z::CustInfo
d) Sales System = Z:SalesSys
e) Alfak Database = ODBC connectivity to Alfak/Gupta database
f) etc
The test cases are to be in a table for ease of editing rather than hard coded.
Please review this and come up with a skeleton design on paper on what you think I want based on the above and we will discuss tomorrow at 9am.
-----Can somebody tell me what he intends for me to do ? I am kind of confused
I spent a great deal of time trying to load up a picturebox with an image stored in an Access data base.
The thing that was most troubling was the complete lack of documentation.
Every feature that exists in VB or Access had many, many man days spent in development. Which means that someone has extensive documentation on it.
Yet, when I went to Microsoft web site to look it up, I was told my product (access) was not supported in the us, but rather I had to pay $99 to speak with someone.
It is a shame that the Microsoft monopoly is able to steal from the consumers and the little developers. Not to get to political but i think it is unfortuante that the bust up of microsoft was averted. It is really a drag to the little developer the lack of documentation and proper development of so many features of their products.
Perhaps I am missing something but is there a place to find proper documentation on the various components - with examples of use?
what means a table to appear as an entity on the diagram? And how to identify the cardinality of a relationship and how to specify which is mandatory and which is optional.
View 5 Replies View Relatedi have a table of listed documents that when a user enters the data i want the location field to have a prefix before they enter the data so that the tabel field will show the prefix + the data entered
i.e. DocumentLocation ="C:Forms" input data
Any help guys?
Hi All,
I searched the forum before posting and couldn't find my problem, or how to adapt similar problems.
I have created a Database for call logging.
I have 2 types of call Change and Problem. I have 2 seperate tables for these. Each have an Auto Number as a primary key. One Prefixed with a 'C' and one with a 'P'. This was all fine, problem now being i have created a new table for Time Management.
I am trying to link the the time to a call, i can link the 2 primary keys to the 'reference' field in the time management, the problem being there are now 2, 000001, i can manually re-attach the P or C, but i want to write a report to see who's logging the most calls, to do this i wanted to use the time to look accross to Problem or Change and show the User ID, but when i query C000001, it show's no matchs as all thats stored in the table is 000001.
Any help or advice would be much appreciated.
Thanks,
Ian
I found instructions that said in order to prefix an autonumber i.e. AAA000 you would have to write "AAA"000 in the format section under the general tab in the table design view of the field you are interested in.
I did this however even though the number now appears as AAA000, AAA001 etc in the table it does appear this way in the form - it just appears as 0,1 etc....
My actual prefix is 2006/1010/ i.e. 2006/1010/001, 2006/1010/002 and so forth.
Anyone have an idea of why not?
I have been looking at the way I name fields and thought I'd Google the topic. Seems to be a split as to prefix names or not. Looks like the SQL Sever and Oracle groups say not to while Access users are kind of directed to use them...
While I have not prefixed names in the past, I was going to do my next db with the things like:
intMyFldName
strMyFldName
etc...
Where as in the past I would do something like:
my_fld_name_one
my_fld_name_two
etc...
What do you all see as some of the pro's and con's?
So I have a table with a bunch of data, InventoryID is the autonumber field which just increments normally, what I want to do is stick 'S000' in front of the autonumber, and for this to be the default prefix for any new items in my database - how would I go about this? I'm guessing some kind of append or update query would do it, but I'm no access whiz, help appreciated folks.........
View 2 Replies View RelatedI wish to avoid the SumOf, AvgOf prefix in queries. I am aware that I can write sales:sales but in a query with 50 columns that is somewhat annoying.
Any help would be appreciated.
I have a database with a field called "Drawing Number".
I can set it up so that the prefix "STD." always appears and then I type in the relevant number.
BUT I cannot figure out how to set up autonumber so that the "STD." appears and then the auto number is added????
Ok...I've looked at old threads and now I'm more confused than before.
I'm trying to find a way to make my field "PCRTrackingNumber", work like this: 05-0001...05-0002...05-0003...and so on. The 05 represents the year. I currently have the field setup as autonumber, set to Long Integer and increment. Even if it looked like 05-1...05-2...05-3...etc. that would be fine. Basically just looking for a way to add "05-" to the prefix.
I was trying to think of a way to combine a field to the autonumber field and use that instead...but need some help.
Thanks, Jeff
Is there a way to prevent Access from the absurd notion it needs to concatenate 'DBO_' as prefix to tables linked from SQL Server db? :mad:
Thanks.
I want my JobCardNumber field in table T-JobCards to add automatically month number.
e.g. For January
1-00001
1-00002
1-00003
For February
2-00001
2-00002
2-00003
OR
Jan14-0001
Jan14-0002
I know the method of setting format in tbl as 000 etc.. but this is one specific.
Getting better - but still far from being competent with VB can someone please help me with the following code.
On the On Click event of a command button I want to call up a field (from another table/form) and add A to it so it lands in a text box. So using the following example -
The table/form is called Patient and the field in question is URNumber. The form I want to put the command button is called RelatedDetails, and in a text box (IDNo) I want to put code that creatsed URNumber with an A on the end (or the beginning) Any ideas?
How could let me get auto invoice number.... like press Button or combo box??
Here we got some related info: 10 customers, each I'd like to get invoice number with their own prefix, example ICP, CUC and etc...
Then, I would like numbering to be incremental from each customer, mean: CUC001, CUC002, then, ICP001, CUC003 and so on...
When I need to put these invoice number into Data Entry table which like below:
Load Date>>Customer>>Particular>>Quantity>>invoice No
1/Jan/2014>>ICP>>part A>>100>>ICP001
3/Jan/2014>>ICP>>part B>>200>>ICP001
5/Jan/2014>>CUC>>part C>>50>>CUC001
18/Jan/2014>>CUC>>part B>>200>>CUC001
23/Jan/2014>>ICP>>part C>>50>>ICP001
I could not use 'Auto Numbering' for each line, as I need out some lines accumulated for one invoice number 'ICP001'.
My questions:
1. What can I do to let me Automatic generate invoice number which increment from last number?
2. What can I do to let me easy to put those 'invoice number' into my Data Entry table's invoice number field? (p/s: Append Query? Update Query?)
3. What if I need sorting (example to group ONE customer and ONE Particular) for my invoicing number? What I meant is ... let say there is 30 lines customer CUC with particular Part B in a same month, and I wanna get them into same invoice number.
I'm making a new database and I want to assign Item Codes to my inventory. For example:
ItemCode (Primary Key) | Item | ItemDescription
I want to generate an automated item code containing the first letter of the Item (as prefix) followed by numbers. Example:
ItemCode: P001
Item: Paper
ItemDesciption: Ordinary white paper
My database has three tables with many columns. The three tables are identical in the names of their columns.
I want to copy all columns from all three tables together into one single table, giving the respective columns prefix table1-, table2-, table3- since the columns would otherwise be indistinguishable.
I already tried to search the board for "table columns add prefix".
I use Access 2010
I managed to copy all columns together into one table through design-view, but cannot figure out the "add prefix" step.
I have a module which generates an autonumber based on a table content (Tbl:Numbervalues) and a prefix (prefix held in Tbl: TextValues)
the module itself works fine and after every getprefix & getnextnumber it updates the number within numbervalues table to the next unique figure.
However what i want it to do is within my database i want to loop through all the records and update a column based on the getprefix() & getnextnumber()
so at the moment lets say column A has values of SHA000001 (in all 100 records) i want it to loop through those 100 records and update to be SHA(from the prefix table) and 000001 all the way to 000100.
Code:
Public Function GetPrefix() As String
On Error GoTo GetPrefix_ErrorHandler
GetPrefix = DLookup("Value", "TextValues", "Description = ""InvoicePrefix""")
If Len(GetPrefix) <> 2 Then
msgbox "The Invoice Prefix Value in the Text Values Table is not 2 characters long!", vbCritical, "Critical Warning"
End If
[Code] ....
How to add a prefix to an existing description in a project table, generated from the project number. Here's a sample of my data:
PROJECT NUMBER DESCRIPTION
01200000 Completed Projects
01601530 Steele Sub
I would like the Descriptions to read:
01200000 MO-20 Completed Projects
01601530 MO-60 Steele Sub
The state, "MO," comes from the first two digits "01" and the coop, "60," comes from the second two digits. I have a table of a thousand or so projects in an Access database that I need to amend the descriptions of to include these prefixes. Is there a simple way to do this in Access or in Excel without writing code?
I have a table which will contain project information, and want the ID field, which auto assigns a unique number to each record, to be formatted like this P12-001, where 12 = the last two digits of the year the record was created. I know that if I type into the format field "P"00"-"000 i get the ID number in the format I want, but cannot figure how to get the first two zeros, to be the date format.
Further, I would like the ID numbers to restart from 1 each year, so this year this first project, P12-001 and may run through to P12-063, then the first project I enter next year to start P13-001.
I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
View 2 Replies View RelatedHi,
I have a form which has a subform. For each record, I have to assign a user, which comes from a user table. Due to the large number of users I have created a user selection form, which is designed as a popup. This form has an option group to select department, which then filters a combo box for selection of a user. On clicking a user, the window closes and that username is inserted into the form.
Since this particular user form will be used in multiple locations, I was thinking of having a global variable, which is set when a field is clicked. i.e. a variable called nameSelect. When a user is being assigned in form A, the user field is clicked, nameSelect = 3.
I was then thinking of having within the user selection form coding a Select Case function which depending on the value of nameSelect assigned the selected user to the correct location.
Is this the best method to tackle this?
I am writing an event procedure to check to see if a particular Project number exist in a recordset. I am trying to use the findfirst method and are having some problems. Here is my code.
Private Sub Command3_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset, ProjectNo As String, SqlStr As String, StrProjectNo As String
Set db = CurrentDb()
Set rs = db.OpenRecordset("tblTrackingSheetFrm", dbOpenTable)
StrProjectNo = Me![ProjectNumber]
rs.FindFirst StrProjectNo
If rs.NoMatch Then
Forms![frmProjectCriteria].Visible = False
DoCmd.SetWarnings WarningsOff
DoCmd.OpenQuery "(1)qryDeletetblTrackingSheetFrm"
DoCmd.OpenQuery "(1A)qryDeletetblTrackingSheetTMP"
DoCmd.OpenQuery "(2)qryAppendProjectTasks"
DoCmd.OpenQuery "(3)qryMaketblLaborActuals"
DoCmd.OpenQuery "(3A)qryUpdatetblTrackingSheetTMP"
DoCmd.OpenQuery "(4)qryDeletetblMaterialActualsTMP"
DoCmd.OpenQuery "(5)qryAppendEquipment"
DoCmd.OpenQuery "(6)qryAppendInventory"
DoCmd.OpenQuery "(7)qryAppendPayables"
DoCmd.OpenQuery "(8)qryAppendPurchaseOrder"
DoCmd.OpenQuery "(9)qryUpdateMaterialActuals"
DoCmd.OpenQuery "(A)qryAppendtblTrackingSheetFrm"
DoCmd.SetWarnings WarningsOn
DoCmd.OpenForm "frmTrackingSheet", acNormal
Else
MsgBox " Project worksheet already opened by another user."
rs.Close
End If
End Sub
What this does is check to see if another user has a project open and if so doesnt allow that user to access that project. I am getting the following error when I execute the procedure on the findfirst Code line.
Runtime error 3251 Operation is not supported by this object type.
Can someone take a look and see what I am doing wrong.
Any help is greatly appreciated.
Hi
I just want to ask what is the best method to deliver an application to the user. The reason of asking is that it needs user to have access software installed which is not cheap Any other method that can help, some sort of exe file that can run without access software or atleast something free...
R
When trying to use FindRecord I get a "Runtime error 2406 - the command or action 'FindRecord" isn't available now". The script up to that point is as follows:
Sub Test()
Dim Connection As New ADODB.Connection
Dim Catalog As New ADOX.Catalog
Dim rstRain As New ADODB.Recordset
Dim ppn_0900 As Field
Set Connection = CurrentProject.Connection
Call rstRain.Open("0800Rain", Connection, adOpenForwardOnly)
DoCmd.FindRecord "10", , False, acDown, , acAll
Can anyone point me in the right direction?