Search results for query: *

I have a report that accepts one parameter with a stored procedure for it's record source. I have a frame with four values - "Past Clients", "Current Clients", "Prospective Clients" and "Show All Clients". The first three work fine but I can't seem to get Show All Clients to work with the...

I want to have the ability to check for a duplicate entry - if duplicate, go to the existing record, else allow new entry. It seems that every entry I type in is "duplicate" even when it is not. How can I fix this - or is there a better way? any help/guidance is much appreciated. Thanks...

I've searched on the popup form on here, and sad to say I don't quite understand the answers. Hopefully someone can enlighten me! I have a continuous form that creates a marketing log and I have a button that when clicked will open another form in continuous view to let user enter all...

I have a continuous form that I want to allow the user to choose in the header of the form a district once. when the user chooses a district, the continuous section (detail) will be made visible, allowing the user to enter multiple records for that district. my problem is - i want to filter...

This is probably an easy question... I have two combo boxes linked together - the first one chooses the state, the second then chooses a county. What I want to do is when the choice in ComboBox1 is picked, clear any current value in ComboBox2 so that I can pick from a list fresh. Right now if...

I'm having trouble trying to figure out why a recordset is no longer updatable on a form I'm using. The table has a primary key, so that's not it. I haven't done anything different. Can a user entering information somehow create an error that would no longer make a recordset editable? Here...

I have a tabbed form that on one page it calculates the totals of a continuous form in a footer and is then referenced by another page in my tabbed form. Here's the weird part. Anywhere that my continuous form has to scroll down, the field that references the footer shows up blank. Every...

I wrote this code to sum four fields based on the ContractorID grouping (there's a left join to get Contractor info from a different table and list the contract price even if there are no change orders). When I run the procedure, I'm getting the overall sum for the project number, not grouped...

I am trying to populate a field on a form that will give me the sum of two numbers if that project number exists or return a zero value if it does not. Table ProjectNumber (check to see if there is a project number) PropCost (sum) AppCost (sum) If there is a record, my equation works but...

I have a tabbed form that I want to be able to use information from one tab to populate a textbox on another tab. I have on the first form a listing of all contracts with their bid. The second form needs the sum of all contract bids shown. What is the best way to do this? I tried creating an...

I set up a filter for a combo box on my form but I'm trying to figure out why when I click in my combo box and choose what I want to filter, it won't filter the first time. If I click an item to filter a second time, then it will work. Has anyone seen this/ know what I'm doing wrong? Here's...

I have three tables, one of which needs to be a many-many relationship. I cannot figure out how to do this, since if I don't have a primary key, I can't enter information. Table1: IDContractor ID (Primary Key) Descript Table2: ProjectCt ID (Primary Key) Name (Primary Key) <other info> Table3...

I have two combo boxes to filter records - upgraded to access project (adp) with sql server backend. everything works fine as the database owner, but if I try to do the same thing on a user station with connectivity only - i don't get any records with the filter. does anyone know why? i'm...

I have a stored procedure that provides input params to an access report. for some reason, the report will close as soon as it opens on another user station. I don't know if it's a sql server problem - user permissions, an access problem (pretty sure it is). Can anyone help? this is my code...

How do you work around a name that contains an apostrophe? Ex: O'Neal. Do you strip it out somehow? If so - how? Thanks in advance!

I have a form that allows users to choose how far back they want to retrieve records based on number of years, which in turn will be sent to a stored procedure. I'm not sure how to filter records based on a date - X years. Can anyone lead me in the right direction? Thanks in advance!

I have a query to search for a person that worked on a project. I have five different fields that the persons name could be listed under, depending on what they did in that job. Ex. Person1 could be listed as the ProjectManager or could be listed as ProjectDesigner or as StudioDirector. I...

I have a report that I am converting to an access project, upsized from an mdb. The form contains 10 different options to let the user base their search on. For example, I have boxes for state and project type, if the user chooses just the state option, i want the recordset to return all...

Can anyone tell me how to pass a "less than" integer parameter to a stored procedure? Set parOpt = cmd.CreateParameter("COption", adSmallInt, adParamInput, 4, cid) This works for an integer, but when I try to pass the "<" symbol I get an error. Is there any way to do that?

I have an .adp project that I'm trying to create a report for. I have a stored procedure that accepts a parameter. After the procedure runs, I open a report based on what records the stored procedure retrieves. My problem is that I have a report that I want to have a sum based on an id number...