MattFitzgerald
Last Activity: Sep 19 '16, 03:43 PM
Joined: Jul 17 '07
Location:
-
I just tried ping -a then the IP address to find out the pc name, this did not work any ideas why? In the mean time I will get the pcname by telephone.Last edited by MattFitzgerald; Apr 23 '08, 02:54 PM. Reason: Edited because my punctuation yet again was/is applalling (as you can see I'm not sure on my grammar either) -
NeoPa
I do not know much about networks or naming conventions and the 2 files are not on servers we have peer to peer networking in both our offices with a VPN connection between LANS.
As they are not on servers should I use the PCName instead of ServerName and do you think the PCName will resolve back to the correct IPaddress at the other end of the VPN as is this not the job of a DNS server and we don't have one of...Leave a comment:
-
Fishval
Thank you will try this method next time this happens.
I figured out that if I set up my linked table by browsing through My computer it uses the drive letter but if I browse through My Netwok Places it uses the IP Address.Leave a comment:
-
Linked Table Manager and IP Addressing
As a company we have 2 sites and the same database is replicated at both sites
I link the tables from both these sites into my reporting database using linked tables.
The only problem I have is when I link some tables the link uses the mapping format Y:\ instead of the IP format \\192.239.14.11 5\.
Is there any way I can replace the Y:\ with the IP format in the Linked Table Manager as I can only use... -
I want to Access a Subform based on a selection in another form
When I open my database I have a comand button "Search Orders By VOL"
This opens a form containing a dropdown list "Combo4" from here I select my order reference [VOL Ref] e.g. VOL011-0000000004 and click a command button "Open Customer Orders" which opens a form "Frm_LE_Lis t" to the correct customer [LE ID], but I do not know how to make the Subform "Frm_VOL_Refere nces" open to the... -
Thankyou for all your helpLeave a comment:
-
To be honest I had not realy given linking the tables any consideration as I am not certain how that works.
I am pulling data from 2 databases as we have 2 sites and the data from the other location is downloaded by broadband link and the database I am importing to is for running reports so my thoughts are each time I run a report with linked tables I am going to have to wait while the data is refreshed from the remote site.
...Leave a comment:
-
Can I put a password into my VBA code when Importing a table
I am using the below code to import a table when the code run I get a pop up box asking me for the password for the database I am importing from.
Is it possible to put the password into my code so I do not receive the password prompt?
...Code:DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\Documents and Settings\fitzgem4\Desktop\2008_2009 V5.mdb", acTable, "Tbl_VOL_References", "Tbl_VOL_References_StratfordData",
-
I think part of my problem is I do not fully understand the difference between
.Recalc
.Refresh
.Requery
as I think in some of the problems I have been having is if I use .recalc on a subform it seems to update the main form details as well and I should have used refresh.
can anyone explain the differences between these 3?
And any pitfuls to watch out for as I think in my learning...Leave a comment:
-
Am adding updated zip so can see where upto so far any other suggested improvements are welcome as I may not be structuring things in most efficient way and any advise is much appreciated. Especially advice on best ways to refresh forms after making additions e.g adding new LE then being able to select it....Leave a comment:
-
I have almost resolved this now
I created a form based on the rate table and when I click add record this opens.
I then added a combo box and using the combo box wizard selected the option allowing your selection in the combo box to select the record set.
I added a button to this table saying proceed which opens a further form which is based on the table Tbl_Order_Lines and the default properties look...Leave a comment:
-
Populate fields in a table using fields from another table
My Forms & Tables:-
Main form is Frm_LE_List (contains Customer Details) Stored in Tbl_LE_List
Which contains subform Frm_VOL_Referen ces (Contains Orders known as VOL's) Stored in Tbl_VOL_Referen ces
This subform has subform Frm_Order_Lines (Contains line items for orders) Stored in Tbl_Order_Lines
I also have a table Tbl_Rate_Card_L ookup (This contains information used to populate Tbl_Order_lines
R... -
Thank you I did mean username and I now have it workingLeave a comment:
-
Save using Current Date and Current user profile
Hi hope some one can help I have 2 questions:-
Question 1) When saving a file in access to excel how do I specify current date
Question2) When saving a file in access to excel how do I specify current user profile
To be more specific I have a Macro in MS Access and I have selected Action "Output to"
The Output file is currently set to:-
C:\Documents and Settings\Fitzge m4\Desktop\Cadb uryData_Date... -
The probem of putting in Excel first caused more problems than I thought as cells in Excel have a smaller limit than Access Memo fields so in some instances my notes fields were incomplete.
I have however managed to resolve by importing the old table and using a unique reference field between the new and the old tables and used a make table query to replace the Notes fields in the new table with those from the old table.
...Leave a comment:
-
Putting Returns back in notes fields
I needed to import from an old table into a new table but the tables were not exactly the same so I first exported to excel and made some alterations before pasting into the new table.
All worked fine except for my 2 notes fields which now have little square boxes where previously there were returns.
Is there any way I can do a find and replace. My problem is I do not know when doing a replace how to put the square box... -
I am not looking at finding the duplicates when looking at the 2 tables. I am trying to find the duplicates in the union query that combines the 2 tables.
As I have probably confused the issue with too much detail below I have what I am looking for in the simplest terms:-
I have a query which contains a [VOL Reference] and a [GP Agent] claiming they own the order . But I have duplicates of the [VOL Reference]. What...Leave a comment:
-
Selecting records where a field is duplicated
Can you help I want to reduce the number of queries I use?
I have a union query which combines data from 2 different databases located at different sites. Both databases are identical each of these databases does not allow duplication of field [Vol Ref] this does not stop their being a duplication as that Vol Ref could be entered once at each site and I have a duplicate when they are merged. I am trying to create a report that highlights... -
FishVal
Thank you very much for all your help and patience my listbox now works.
I have one last question regarding this:-
In my Listbox properties I have made the following changes
Row Source type = Value List
Row Source = "Newport";"Stra tford";"Telesal es";"Joint"
Default Value = "Newport";"Stra tford";"Telesal es";"Joint"...Leave a comment:
-
FishVal
Thanks once again
I tried your suggestion but I think there was something else wrong with my code. I found in a book on Access containing a section on trouble shooting where I found out about break points and setting a watch on my Variables and Strings.
I could see from watching my variable that the values from my variable did not populate my string as expected.
I have since found...Leave a comment:
No activity results to display
Leave a comment: