I created one MS access database and I added some table in that and I have other access mdb file with same name so when I open the first one file and I copied the second one file in same location it asked me to overwrite but I have using that file my issue is that while using access file if I am overwriting it wont allow me to overwrite it has to stop doing. Is their any solution for this.
The code below successfully saves a .pdf file to my c: drive. However, on occasion i want to overwrite a previously saved invoice e.g. 3815-140515-Bristol with an amended invoice but retain the same Invoice Number e.g. 3815-150515-Bristol.
Currently, if i save the invoice with the same invoice number but a different date it just saves down without overwriting the original invoice. Leaving 2 invoices with the same invoice numbers but with 2 different dates.
What I want to achieve is: Once I hit the SaveInvoice button the code will check that invoice Nr 3815 does not exist in c: drive and save normally. However, if it does exist a msgbox will then prompt me to overwrite.
Current code:
Private Sub SaveInvoice_Click() 'Save Invoice as PDF and annotate invoice number, site name, and date Dim slFileName As String ' create the invoice as a pdf slFileName = Me.txtInvoiceNr.Value & "-" & Format(Date, "ddmmyy") & "-" & Me.SiteName.Value & ".pdf"
I am in transportation and am designing a form for bills of lading (air/sea/truck). There are two tables, a NameAddress list, and the BillOfLading record list. The bill of lading form has a drop down combobox to let the user choose a Ship From name and address, and another for a Ship To name and address.
The simplest way I can think to display, and later report-output the names and addresses is with subforms for Ship From, and Ship To, or alternately, using DLookup fields. Both methods seem to work fine.
But in this business, the user, a shipping clerk or agent, is often called on edit a name or address text in the Ship To or Ship From, usually for a one time occurance for the specific shipment, rather than for a change for the Name or Address list. That change might be a request for adding a purchase order number, or a pickup number, to an address field. This change might occur rarely or regularly, but often it must be placed in the address lines rather than elsewhere on the bill of lading.
With subforms, I seem to have been able to set it up where you can edit the address field, however, when doing this, it has always meant that the related record in the NameAddress table gets changed by this editing.
So the question is, would it be better to create real name and address fields in the bill of lading table, and somehow have the related NameAddress field data written to those fields? Then, if required they could be edited for the specific shipment and that that bill of lading data record would be saved. If so, how can I write to those fields from the related record in the NameAddress table?
Thanks for any help or suggestions.
(PS: I know that doubling up on name and address fields breaks a rule in DB design but I don't see how to avoid it in this case.)
I have a table that contains a notes field. What i would like to do is to append to this field in table with some more data (notes), however i dont want to over write the existing data. I would just like to add to it.
the current notes are added through the access front end, but in this instance i have a particular note that needs to be added to various enteries without overwriting existing data. I know this is to be done via an append query, any help would be great
I have a table where csv files get imported to on a daily basis. The key fields I am working with are a supply number and date. The problem I have is that sometimes the csv file will contain information that is correcting/updating information held in the table. This is creating duplicated records.I need to either create a query to find records that have the same supply number and date or find a way of overwriting the records in the table with the new data.
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
I have a button in the form of the current access file. What I want to do is when the user click on the button, triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?
I have tried two methods but failed: 1) Use copytofile method, but I get permission denied due to file open; 2) Use dbengine.compactdatabase method, but it also has problem if the file is open.
I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.
Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?
I want to make some changes in .MDB file and i do not have it. I have only .MDE file.. Could you please let me know how i can convert .MDE file into >MDB file so can change tabelsa nad reports...
i want to convert accdb file to an exe file that not display any design view in other words i want the user watch only the forms and handle with the application as a program.
I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
I have a .mdb file that was created with Access 2000. Before I upgraded to 2003, I opened the file source by holding down 'shift' and double clicking the file. Now when I do that, it runs the application. How can I open the source file again.
I'm not sure if this is even possible but I have a table which has a list of Categories(text) and another field named filepath(also text) which contains a file path which points to specific pdfs. So my question is Can I create a report which then prints the categories with a button next to them which if clicked on opens the coresponding pdf ?
Any help will really be apreciated I am a database novice but am really good at following instructions and copying code :)
I just recently noticed that the database that I have been working on has changed from around 60 mb to 430 mb. I added a few queries and forms. But could that really add to the size that much?
hello to the experts is there any way or method to compile an access .mdb file to .exe and don't be the need to open it with the access programm? (eg. to a computer wirh no access installed)
an access file shows that can't find (as it says) the object database!!!! & don't opens... the file is 3.5 mb and was working till yesterday just fine but today without no reason doesn't open...!!!
I can still open my file at work, but the same file at home cant be opened. It keeps giving "microsoft access has encountered an error" etc.. send error report..