Search results for query: *

I'm at a loss as to what to search on for this. I have a form with client notes, including 'clientid'. I have a command button that, when clicked, it will open another form to add a new notes for the same client. I want to carry over just the 'clientid' to the new form and nothing else. I've...

I'm trying to run qryNotes to just show the latest records for clients. Everything I've looked at points me to using "Last" or "Max" but I always get the error "You tried to execute a query that does not include the specified expressions expression 'clientid' as part of an aggregate function"...

I'm sure I posted this last week but it is no where on the forum to be found so I'm trying again. I am trying to do a simple thing with stLinkCriteria and it simply will not work. I am getting the error "..Access cannot find the field 'clientid' referred to". Private Sub Command2_Click() Dim...

Would someone mind looking at my .aspx page and pointing out anything in it that could be keeping my page from being viewed on our intranet web server? web.config <configuration> <system.web> <appSettings> <add key="connectionstring" value="Data...

I have been unable to find an answer to this and am hoping someone here can help me. I am using a split Access db with a copy of the front-end on my web server (it's an internal one administered by my company). The back end resides on a shared network drive. I have created an .aspx page which...

I have created an asp.net form page which inserts the inputted data into an Access db. I have some form fields that are not required, but, when left blank, I am getting an error message stating that the values are missing. I have them set up in my Access table as not required. Has anyone else...

I am very close to this working but am hung up on a syntax error (Run time error 3075 in query expression). Would someone please take a look at my code and see where I could be going wrong? "qryProjects" is the recordsource for the form "Projects". Is it even possible to filter a form based on...

Would appreciate some keywords or a point to a thread that could help me with this. I know the answer must be here somewhere but I've exhausted all ideas. I have a query with calculations in a column [Savings]. I have a form with two text boxes for dates, "txtStartDate" and "txtEndDate". I...

Could someone please tell me what type of query/function I should be looking for to accomplish this task: I have a table of projects. Each project has a cost savings effective date, i.e. 5/1/06. The total savings for each project is based on monthly volumes in another table. I have to...

I have split my db with the back end on our network server and have installed the front end copies to everyone's machines. I have one user so far that it will not work for. There are no missing references and all of the ones needed seem to be checked. My form has a tab control with 4...

I am attempting to create an Access query to sum volumes across months for products based on the effective month entered in my table. I used DSum in my query grid but it is obviously the wrong thing to do as it is generating thousands of rows and locking up my system. I am looking for some...

I originally was trying to do this completely with Access but have decided to go with ASP.NET for the user interface. I am trying to automate a form and create a word document from it. It is a form which users fill out to request part number files be sent to suppliers. There can be multiple...

I have a query which includes a query "Parts_List" and a table "BOM" Query fields: seq_no (Parts_List) level (Parts_List) seq_no (BOM) level (BOM) Parent Level: [BOM.level]-1 Parent_Sequence: DMax("[seq_no]","Parts_List","[Parts_List]![seq_no]< [Jupiter_LP2_BOM]![seq_no] AND...

I am trying to automate a form and create a word document from it. It is a form which users fill out to request part number files be sent to suppliers. There can be multiple part numbers and file types requested per form with no maximum (except for page space) i.e. Form structure Part Number...

I have looked through all of the posts in "Forms" and "VBA Coding" for checkboxes and cannot find a relevant one. I have a form based on a query. The data is identified by "subtype" (SolidInk,OEM, etc) and "status" (Active,Tabled,etc) Right now I am just using macros with command buttons to...

I have been using a calendar control on a subform and have now split the data into a tabbed form with 4 subforms. The calendar is now entering the date selected into the first record of each subform instead of just the one on the subform that has the focus. Do I need to add the calendar control...

I'm sure the answer to my question is in the forum somewhere but I can't figure out what I should be looking for. I have a page with a drop down list (DropDownList1) and a Select button. When the item is selected from the ddl DataGrid1 appears with the appropriate data. The first column of...

Could someone give me some keywords to look up to find out how to do this? I have searched almost every post in Tables, Reports and Queries with no luck. I have a form "Projects" with 6 date fields (cutinact,cutinplan,etc.) The rowsource is SELECT [tblMonths].[monthid], [tblMonths].[month]...

I've had a split Access 2000 database residing on our network server for a couple of years. I use a batch file opened by a hyperlink on our company intranet page which has been working great. cd "c:\my documents" copy v:\Project\Materials\PurchSQE\Training\MaterialsTraining.mdb "c:\my...

I have created some asp.net pages using Web Matrix and am trying to move them to our company server which is running IIS 6.0 on Windows 2003. I'm not sure what I need to do to get them to work. I have a web.config page in my main folder "Acquired Products" with the .aspx pages but am...