Modules & VBA :: Microsoft Office Can't Find The Field StartDate
Feb 18, 2015
I have a main form that has a combo box (cboCurrentEmployeeName) to select an Employee Name. And then there is a subform within the same form that displays the list of active tasks.The record source for the subform is a query. The query is as follows. Please note that the tables are joined on employee-id and not the employee name.
SELECT TasksEntries.Project, TasksEntries.Task, TasksEntries.StartDate, TasksEntries.Status FROM TasksEntries INNER JOIN (SELECT EmployeeId FROM Employees WHERE Employees.EmployeeName=Forms!frmMainForm!cboCurren tEmployeeName) AS EmpList ON TasksEntries.EmployeeId=Emplist.EmployeeId WHERE TasksEntries.Status<>'COMPLETE';
The names of the fields in the subform are Project, Task, StartDate, Status and these are present in the subform only and not on the main form..I added an after update event on the cboCurrentEmployeeName which is as follows
Private Sub cboCurrentEmployeeName_AfterUpdate()
Me("StartDate").Form.Requery
End Sub
When I select an employee name from the combo box I get a runtime error 2465: Microsoft office can't find the field StartDate referred to in your expression. I get the same error doesn't matter what field I use.
I had a Label in the form that when i started design the Form, I supposed that will be permanent. After few records, users needed to change the Text on that Label depending the customer they reffer to. Therefore i attached a Microsoft Word Document OLE Unbound Object to give permission to users to change the text when they need it. But if u change the text in one record then will change to all of the other records. Can u give any idea how i will manage to have a default label for all the records and users when they need to change the Text only for a particular record. Is this possible? Or I need to declare it as a Field on a Table therefore can be saved in every record? Please any idea... Thank you
Hi, I have created a database with Office developer 1.5 and I am having problems creating my runtime version. I have been told that the VBA included in this program wont do the job, that I must purchase a full version Visual Basic 6.0. Is this true? Thanks all
I'm trying to locate the Developer Extensions so that I can compile my Access 2003 application to distribute to my end user.
I'm getting totally lost in the myriad of documents and links on the MS website that keep sending my round in ever decreasing circles. I've downloaded Visual Studio Express - Visual Basic Edition but can't seem to find it in there.
Can anyone point me in the direction of the software that I need to be able to distribute my Access 2003 applications.
I have an App that runs a few action queries using:
Code: CurrentDb.Execute "[My Query Name]"
At some point I get this Error: The Microsoft Access database engine cannot find the input table or query <name>. Make sure it exists and that its name is spelled correctly. (Error 3078).The query is there, I can run it from the DB objects window.Queries run using CurrentDb.Execute earlier in the code.
I have a main form (unbound) and a main form (bound) and then a subform (or a main form;subform;subform).The main form has the following SQL;-
SELECT Detail.*, Hazards.*, HowHarmed.*, Section.* FROM PSR RIGHT JOIN (Hazards INNER JOIN ([Section] INNER JOIN (HowHarmed INNER JOIN Detail ON HowHarmed.ID = Detail.HowHarmedID) ON Section.ID = Detail.[Subject Area]) ON Hazards.ID = Section.detailID) ON PSR.ID = Detail.PSR;
This form appears to work fine. Essentially, there is a control on the unbound form whereby the user selects the section and it populates the respective form with the various 'detail' of the various records.My tables are as follows;-
Risk Assessments Detail Section HowHarmed Hazards PSR PLR Staff
In the subform there are records from Riskassessments, which is the table in the source property of this subform (and not on the main form) with a link to PSR of which is on the mainform. Again, these appear to work if the record is entered via the tables - all the tables appear to be linked correctly from their respective dropdowns (+ sign) but when I go to add a new record in this subform, I get the error "The link masterfields property has produced this error: 'The object doesn't contain the automation object ID'." When I try to update from this entry the following message is presented;-"The ms Office access database engine cannot find a record in the table 'Detail' with key matching field(s) 'DetailID'.
The SQL for this subform is as follows;-
SELECT Detail.*, PLR.*, RiskAssessments.* FROM (Detail INNER JOIN RiskAssessments ON Detail.ID = RiskAssessments.DetailID) LEFT JOIN PLR ON RiskAssessments.PLR = PLR.ID;
Hi, We migrated on DB to a shared network drive. But the users cannot open the DB. It keep give an error message that microsoft access can't find the database file. Please advise.
I'm lost on how to use the LIKE to find a value in a field.
I try to use the open folder if a field contains "Retail" or any other containing as a part. So, I could have just "Retail" "New Retail" and then act on it.
How can I use the below proper?
Code: If Me.Business_Type Like "*" & "Retail" Then
I have VBA code that makes use of the Microsoft Office 14.0 Object Library, but if I have this selected whenever I try to do anything in the Form Design view it is constantly freezing. It will literally say not responding" for a minute or so then I will have control again.
I'd like to further automate our invoicing system and need a field which has the last day of the month an item was completed.
Currently we have a field in the table called [Date Done]. I'm planning on adding a further field [Tax_Point].
I'd like the field to select the [date done] value and enter the final day of that month, unless, the final date of that month is in the future. in which case it would need the current date.
We create invoices at sporadic times of the month, and in the next month for the previous month; hence the need for a system date check.
My update statement is shown below. What this is to do is change the PGTIN record in PP TBL to the GTIN that is in the UPC TBL where the UPC Code on the form is the same as the UPC Code in the UPC TBL. I am getting the error message "can't find field..." I have double and triple checked the field names but cannot find my error. Both PGTIN and UPC Code are text fields.
Memo field is called [Notes] and data is like this...
5/05/14 - Perry was on another call. LM 2/05/14 - Perry only at centre in the mornings, need to speak to him before sending samples. 13/06/13 - Perry in a meeting. lm 30/05/13 - See Little Hampton Early Learning - s/w Perry, has already received sample and info 29/05/13 - s/w Aspi, said to cb tomorrow and speak to Perry
I want to find each date in the Notes field so I can split the memo field data into another table where the memo field will become multiple records that hold date, text and customer/prospect ID fields. The customer table was easy because there was a <Div> tag before each date. However in the Prospects table there are no tags so how to change my vba code to search for each date before I split off the data.
Here is the part of the VBA code I used to find the <Div> tag in the customer notes field. How to find each date in the memo field? The date is in d/mm/yy format?
If Not rst.EOF Then Do StrSplit = Split(rst![Notes], "<Div>") For x = 1 To UBound(StrSplit)
I am looking to find if a field contains a number and then build a case statement depending on which number is found. The field will contain data just like this:
Quote:
Repaired frequency response and grounding issues. Replaced 2 Hybrids, capacitors, and connectors. Tested MER/BER and operation to specs.
Here is my code that did not work:
Code: If Me.txt_work_comm1 Like "*Hybrid" Then 'Sets up auto priced based on number of hybrids entered '1 hybrid If Me.txt_work_comm1 Like "*1" Then strCriteria = "repair_item = 'Charter RF Amplifier Repair + 1 Hybrid' AND profile_types = 'Alpha'"
[Code]....
To Summarize: 1. I need to find if the word "Hybrid" or "Hybrids" is in the field 2. Then I need to know how many to determine a price
I have a table called login and inside that table is three columns: username, password and admin.
I have the username saved in a global variable called GsUser. How can i find the record in that table with the same Username as the string stored in GsUser and use that record for an if statement which sees if the value of the admin column is "Yes". Im trying to do it using VBA. Im not using a form where everything is bounded.
I have no experience with Access Modules which I think I need to find all the queries that reference a field, in this example: LAWSON_LHSEMPDEMO.R_STATUS
I would like for the module to list all the queries for me that reference this table and field of "LAWSON_LHSEMPDEMO.R_STATUS"
I had the need every so often to quickly find all instances of any (particular) word within the database, without going to the bother of thinking about where that word/subject might be in the data base, I designed a report which does the job nicely. It uses a search form/control, searches and finds all instances of the word (or words) I have asked it to find, then does a report showing all instances of whatever RTF memo fields that contain the word(s).It has to be RTF memo field because (if I wish) it goes straight into the book text I'm writing, and also it searches the book's RTF memo field. . The trouble is, at present, I then have to manually "eye scan" the resulting report to find the occurrences of the "key searched for" word, nestling/hidden somewhere within sometimes quite large chunks of text. I would love to have the report show the found "key word(s)" highlighted in (say) light blue or whatever colour, so that I can quickly & easily lock on to it visually.
I enter the word I want Access to find, into a form called "formfindword" in a text box called Text0. I click on a command box on this form, to open up the report called "Querywhatsandhowschooseword" based on a query of the same name. The query's "what" field (from the main database) has the criteria
= Like "*" and [forms]![Formfindword]![Text0] & "*"
The query's "how" field criteria (in the "or" line of the query design) is also
= Like "*" & [forms]![Formfindword]![Text0] & "*"
I have tried to use the Conditional Format facility in Report Layout view, without any luck.I think therefore that I will need some VBA code (which is totally foreign to me, unfortunately) to make this simple concept a reality.
In the Main Form , I have few buttons and I am writing the following code to open the right form when a button is clicked but unfortunately the code isn't doing anything. No form is opening. I am using MS office 2010.
Code: Private Sub BtnOption_Click() DoCmd.OpenForm "Form1", acNormal, , , acFormAdd, acDialog End Sub Private Sub Form_Load() 'Me!Label1.Caption = "Welcome " & Environ("username") & "!"
My main experience is with MySQL and PHP so I'm kindof stumbling around in the dark here. Heres my story:
We recieved a new server and migrating from (Windows Server 2000, IIS 5.0, Access 2000) to (Windows Server 2003, IIS 6.0, Access 2003) has been nothing but problems.
I have setup IIS to work with ASP, I've also setup a system DSN. The access file was copied over from the previous server. We're running Access 2003 and now I can't seem to get this ASP script to work.
When I try to upload a file to the script I get this error:
Line: 42 Char: 7 Error: HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement expected 'DELETE','INSERT','PROCEDURE','SELECT', OR 'UPDATE'. Code: 0 Url: (URL address blocked: See forum rules)
Its included in a file called FileRead.htm here is the part that refers to the error lines: Code: var TheFile, FileStrm;// Retrieved field namesvar M_ssn, M_inits, M_Lname, M_Fname, M_DSSN, M_ruc, M_paycode;var M_normamt, M_payamt, M_pgrp, M_poe, M_pltcd, Payrollnum, Payrolldate;// var Trash, FieldData, FieldNames;var TrashLineNum = 1;// Create the file Stream Object (ReadOnly)TheFile = new ActiveXObject("Scripting.FileSystemObject");FileStrm = TheFile.OpenTextFile(FName,1,false);// Setup the Database Connectionvar SQLCommand, TheRS, TheConnection, DSNString, Commands, MyDC;FieldNames = new Array("ssn","inits","lname","fname","dssn","ruc","cco", "payamt","normamt","notsureone","pgrp","poe", "pltcode","recstatus","paychgflg","paystatuscode", "payrollnum","payrolldate");// Connect the the DatabaseDataLib.ConToDB();MyDC = DataLib.GetDC();// Get Payroll NumberPString = prompt("Enter Payroll Number","025");Payrollnum = parseInt(PString,10);// Get Payroll DateDString = prompt("Enter Payroll Date","20000101");Payrolldate = DateLib.FromMil(DString);// Setup the Database Connectionvar NumRecs = 0;//MyTest = DataLib.GetRS("PaydayUpdate1");alert("About to cross into the CurExtract!!!");MyRS = DataLib.GetRS("SELECT * FROM CurExtract");
I set an alert after this line but it doesn't pop up.
ANY HELP WOULD BE VERY GREATLY APPRECIATED. I'll be checking this very frequently.
I have a MS Access database which has a web browser control incorporated within . I also have a get screen capture program for "excel" which works magnificent. I would like to incorporate these 2 functions into The Access . I would like to use my web browser control located in the access example to zoom into the picture of a house . Then capture that image and save it into access in the best usable format possible ...
copying all the contents/text from word document and pasted that in the Memo Field, I have a Recruitment database where I have 02 fields on is CV Path (Text Field) that stores the CV Path (Word Document Path) and another text box content (Memo Field) where I would like to copy all the data from the word document to the Content text box (Memo) field.
I have put a Command button on the form...the code to "Copy the content/text" from [CV Path] word document and add it to the "Memo" field.
I have tried to create an MDE database and receive the message "Microsoft Access was unable to create an MDE database" I deleted all unnecessary tables, queries, forms and reports and still receive this message.
I have a question that I have a Microsoft Access database (.accdb) front-end/backend split and I want to give the database to my company client. As we have the different path for the backend/frontend linked. I want some code that will popup if the database location is not found and popup with the dialog so the user then select the backend and it would be ready and there is no need to popup each time the database open, it would run once it did not find the last linked path.
Also I have tried the code of Dev Ashish URL.... but unfortunately it would ask everytime to refresh the table links and I only want to run the process of linking tables when the database start and the linked path not found.
What I would like to know about Microsoft SQL Server & Access 2003 : I am a novice at creating my own database. I would like to use Microsoft SQL Server & Access 2003 . I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 . Now I need to learn about Microsoft SQL Server, and it is very different from Access 2003. I have purchase many bussiness applications over the last 5 years, and fount that over software are to rigid, as I need something very specifil to my bussness. If you intend to reply, please be very specific & in plain English.
Can someone help me ?
1Can Microsoft SQL Server 2000 work with Microsoft access 2003. a.Is this do-able .
2Can Mysql also work with Microsoft access 2003
3What is the difference between Microsoft SQL Server & Mysql.
