I am in major need of help. I am need Access or Excel to notify a user when a change has been made to a table. I have a potiential database/spreadsheet, and this would help me. Can anybody help me out?
I hope that someone out here can help me with this. I have recently had a format change from how I received updated data for my database. I used to update my tables from TXT files. There were several update queries/macros written to import the data from 5 or 6 different TXT files into one table. Well; my source has changed :eek: The downside: I can only get my data from an XLS or CSV file now; but the upside is all the data is only in 1 file.
The macros/queries were written years ago and I've been having migranes trying to figure out how this was all done. So, i've sort of started from scratch. I can easily import the data into a table; I have even gotten our front end of the database working so it's just a click of the mouse again.
The problem I have is that the data that is in this table is linked everywhere throughout this spiderweb of a database! I was unable to import my data into the existing table because that table's field names are different than what I have in the XLS file. I get all sorts of errors when I do this. So I am currently importing into a new table. (I.E. MASS and MASS Imports)
Is there an easy way to update data from table 'MASS Imports' to 'MASS' ?? what I was thinking was to use an update query with both tables and link each line.... Or am I way off base? Is there an easier way to do this?
I have a SQL database with an Access front end that keeps giving me an error "The data has been changed... another user has edited the record.I'm the only user on it, and I'm trying to edit it directly from the table. I already checked my indexes and changed all the bits to ints.
I created a query and one of the fields was "name". In the query it listed the names and then changed to the ID number of the names from the name table. The query was created using the wizard. Why did the query change to the ID number mid report and how do I get it to report only the names and not the ID number.
I have some queries that pull data from one table and other queries that pull data from two related tables. In both cases, how do I prevent the data from being changed after the queries results are displayed? I know I could make a form and lock each field so it couldn't be changed, but I was hoping to avoid having to do that.
A form displays information on a construction site in various text boxes. I want to enable the user to change this information but not until a save button is pressed.
Now I have the problem that as soon as I change the value of a text box, the data in the database is updated.
Is there a way to prevent these updates but still get the text fields to be linked to the attributes of a table?
I have a form that has number entries. I changed the Default Value for these numbers to Null because I dont want 0s (they aren't being used for numeric calculations, they just hold a number). I want there to be nothing in the input field until I put it there.
My problem is, when I start to enter info into my form, access automatically places 0s into all my number entries! Is there a way to avoid this? Or should I just make the fields text instead?
I 'm downloading the excel data from the site and connecting it to access.
In excel the particular column (Time Taken) is in the format of "00:12:26".
After connecting it to access and appending it to the table, the format changed to "12:12:26", the first two digits changed to "12" and the remaining are as it is how it looks like in the excel. I need to change it to format what it looks like in the excel.
Hi, Yesterday something wrong happened with my computer and got hanged! I called a hardware person and he corrected the O/s. I am using XP (O/s) and office 2003. The hardware person told me that he has not changed anything in msoffice. I have already created some applications in access 2003. I have observed that the application swithboard appearace is changed and buttons on switch boards are looking now like access 2000. Then I checked for database window. The Table, Query, Form, Report etc are looking like access 2000 window. I have captured present screen and my earlier screen how it was. Can anyone help me to get original display of my swithboard ?
Select * From tblCal_SlsAB UNION Select * From tblCal_SlsBC;
Both of them have Unique IDs as PK, such as: AB001, AB002, etc for tblCal_SlsAB and BC001, BC002, etc for tblCal_SlsBC. When I do the UNION query I get: 1, 2, etc for both IDs instead. What's causing the ID to change and is there a workaround it? I need to get the same exact IDs I have in those individual tables. Thanks in advance!
Hi, I'm trying to populate a read-only field on a form with the time and date the record was last changed. This is to acheive seeing a list of records that have been updated this week for example. I have this at the moment:-
Private Sub Form_AfterUpdate() Last_Updated.Value = Now() End Sub
When I've updated a record it won't save and when I try to move onto the next record it does nothing, the button clicks but no response. Does anybody have any idea where I'm going wrong or have any suggestions?
I have an complex code. In this code I sent the form value 00712 with query string and an insert SQL command to an Access database. The probleme is that the number is stored as 712 in the database. I do not want that.
Select * From tblCal_SlsAB UNION Select * From tblCal_SlsBC;
Both of them have Unique IDs as PK, such as: AB001, AB002, etc for tblCal_SlsAB and BC001, BC002, etc for tblCal_SlsBC. When I do the UNION query I get: 1, 2, etc for both IDs instead. What's causing the ID to change and is there a workaround it? I need to get the same exact IDs I have in those individual tables. Thanks in advance!
I have a database that contains a table with all tasks made in our team and the time it takes to perform the task. I have another table with month, year and value in which I put month after month the volumes that each task handles. So, in a query I multiply the time to perform the task and the volume; month after month I have different results. However "the time to perform the task" may vary depending on processes improvements that we made. If before I had 5 minutes to perform the task and now I have 2, I change it and then the results on the query are changed for all months. I do not know if there is a way to specify that that change must be applied from the month where it is updated to the following months and not retroactively.
i have two fields that are the same, but in different tables. can i create a relationship so that when one field (in stock) from the purchases table is selected, the same field in the stock table is the same value as the one from the purchases table... i hope i explained it well enough:)
i know this causes data redundancy, but is there any better way of doing this?
Due to the data requirements a negative value is not acceptable, it needs to be zero. The above is part of an Asset Managemnt Program and if the WDCC (Written Down Current Cost) is 0 then the item is written off. How do I change the negative value to a zero. Any comments or suggestions would be appreciated.
Could someone look at my code and tell me why my “Me.TargetDate.Undo” won’t work?
First, let me say that the TargetDate field has an On-Click event that calls a module written by Allen Browne), which is shown below and works great.
=CalendarFor([TargetDate],"Select a date from the calendar ")
What happens is that the Me.TargetDate.Undo event always keeps the date selected in the calendar.
Based on something I read from Rual Guy on another issue, I’ve used the TargetDate_LostFocus routine to check for some additional data entry errors. I’ve tried moving the code in “Private Sub TargetDate_Exit(Cancel As Integer)” to the LostFocus, but it doesn’t make any difference to the Undo. I’ve also tried “I’ve tried “Private Sub TargetDate_Change(),Me.Undo…” but that doesn’t work either. :confused:
Private Sub TargetDate_Enter()
If Not IsNull(Me.TargetDate) Then OldTarget = Me.TargetDate End If
End Sub
Private Sub TargetDate_Exit(Cancel As Integer)
If Not IsNull(Me.TargetDate) Then If DateDiff("d", Me.DateOpened, Me.TargetDate) < 0 Then MsgBox "You have selected a date that is before…bla bla" Me.TargetDate.Undo Me.TargetDate.SetFocus ElseIf DateDiff("d", Date, Me.TargetDate) < 0 Then MsgBox "You have selected a date that is prior to today's date…bla bla" Me.TargetDate.Undo Me.TargetDate.SetFocus ElseIf Weekday(Me.TargetDate) = 1 Or Weekday(Me.TargetDate) = 7 Then MsgBox "You have selected a date that falls on a weekend..bla bla" Me.TargetDate.Undo Me.TargetDate.SetFocus End If End If End Sub
Private Sub TargetDate_LostFocus() If Me.TargetDate > OldTarget And Me.cboAssignToID <> OldAssignee Then MsgBox "The target date can only be changed if …bla bla" Me.TargetDate.Undo Me.TargetDate.SetFocus End If End Sub
I have come across a weird event from the 1st July.
I have a form that inputs dates into the table.......nothing special.......
Form is totally unbound and the insertion to the table is done via DoCmd.RunSQL Insert every thing has been fine until the 1st of July at this point it started saving the date into the table in American format 07/02/2013 instead of UK 02/07/2013 There have been no changes to the database at all to give me a reason why this has happened.
The Table fields are set to Date Fields.
The SQL Insert was set to Date ( #" & DATE & "# )
The date displayed on the form is in the correct format to get around this I have set the insert of the date as a string ( '" & DATE & "' ) AND how can i reformat the dates that are incorrectly inserted to the correct format as they include the date and time 07/02/2012 11:11:47
There is about 1000 lines so manual change will be a nightmare.
I have a "Search" form that I am using to search through a query in a list box of all of my Customers. Once the record that I am wanting to view comes up I highlight it and click a "View" button to bring up another form with the customers full record. When this form is open I am able to update the customer information and add User's to it if necessary.
My problem comes after I click on my save and close button that takes me back to me search form. I want to close the search form and the error I get is "The record cannot be deleted or changed because table "tblUserProfile" includes related records." I click OK and get a SECOND error stating "You can't save this record at this time. MS Access may have encountered an error while trying to save a record. If you close this object now, the data changes you made will be lost. Do you want to close the database object anyway?"I have already made my changes and saved them in the form with the customer record so am not sure why I am getting an error when trying to close the Search form.
I am using an embedded macro on the view button. OpenForm with a Where condition [tblCustomerRecord]![Profile ID]=[Forms]![frmSearchCustomer]![Profile ID]
I have the listbox bound to the Profile ID. I have not been able to get the view button on the form to work without this step.Is there a better way to view a specific record from my listbox results?
In Access 2010, I have a database with 2 tables "group" and "member". They have a many-to-one relationship with nultiple members per group. Group has identifier "ID" and Member has field "Group Code" that matches with "ID". Formerly we called this field "Bulgiin kod" but needed to translate it. When we changed "Bulgiin kod" to "Group Code", now when we expand the group records (click the + button next to the row) it gives "enter parameter value" box. I tried deleting the relationship and re-creating it but without success. If I change the Group Code back to its original value, everything works fine.
Here is another thing I noticed: if I enter the value of ID into the parameter value box, it just shows the entire Member table, regardless of the actual matches. So if I expand ID #15, and enter "15", the whole Member table displays under the record.
Within my main table / form I have six status drop down boxes and would like to record with a date and time ever time they are changed and save this data in a second table.
If I cant do this with the six drop downs, can I do it if any change has happened to the recorded.