• Handling Record Update Collisions

    I have a split database. A form on the front end allows users to input their updates and then press a "Save" button to send their updates to the back end database. If two users simultaneously try to update the same record, one will connect, lock the record, and the change is committed. The other...

    MarvinM8050 pointsBadges:
  • Forms in Access 2007

    I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem?

    Jenkinac40 pointsBadges:
  • Access 2007 invalid procedure call or argument (runapp)

    Hi. We have a proprietary Access Database/program that a former employee created for us. We have no knowledge of how to fix it, most of the time it still works just fine.  A user in our office gets the error in the subject when he tries to run it. It worked fine up until a few days ago and I have...

    Longshot95 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend10 pointsBadges:
  • Making a POS form for a pharmacy program

    I need to make a POS frame for a pharmacy automation program am working on. >need to add data from a field in access in which it searches while I type. >when I select the name, the data from the access corresponding the name selected should be added in my flexgrid list and should be asked to...

    josewan5 pointsBadges:
  • Access 2007 database errors when using Access 2010

    I have a database built with Access 2007. Some of our customers are upgraded to Access 2010 and cannot open the database anymore. Error is "The expression On Timer you entered as the event property setting produced the following error: Object or class does not support the set of events". Anyone...

    Browntr15 pointsBadges:
  • Find Due Date From X months in Access 2007

    I have a database that has several different training topics each that a due at different intervals. I have a date completed field [Date completed] and reoccurs every x months [recurrence] and then the next due date [due date]. How do I get my database to calculate and store the next due date?...

    Desnyder200155 pointsBadges:
  • How to use lookup query to return only entries matching the related field of active record

    I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

    YesMayhem5 pointsBadges:
  • Help Creating a Training Record Database

    We have an employee database that the managers want to use to track mandatory and option training. We already have an employee table, and I added two more. tblEmployee   (EmpID,EmpName,EmpProgram,EmpStatus,HireDate)  Has the basic employee information tblCourse      ...

    RaeLyn10 pointsBadges:
  • Need to modify an existing form in Access 2007

    I have just migrated to Access 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.

    Mantis5 pointsBadges:
  • Access 2007 creating a menu

    I have inherited an Access Database. There is a form that provides a menu for user access to the various functions such as adding, changing records and various reports. Originally the users would only see this menu form. I modified the form and now they see Access and all the various Access...

    LeChat80 pointsBadges:
  • Query by character length in Access 2007

    I want to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?

    Skb195510 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • Access 2007 IIF statement in query criteria

    This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought. It seems like I'm getting close but can't...

    Scubacy25 pointsBadges:
  • How to make Access 2007 database GUI

    I need help. I have created a small database, now my problem is I would like to build it in a more software-like interface. No more tools or any options of some sort from MS Access to display but only the navigation form which I designed. Is there any developer tools required? Thank you in advance!...

    Curiousnoob15 pointsBadges:
  • Access 2007 Database – Security Warning

    This database has come back to haunt me.... We recently changed out a computer and added a shortcut to the Access database. Actually it was the shortcut copied from the previous computer. When they double click the short cut, it takes them into the database menu as before. However, now it displays...

    LeChat80 pointsBadges:
  • Using a Linked Table to Create Auto Updating Excel Sheets

    I am having trouble figuring out if I can have one master spreadsheet in excel, link it to a database in access, apply filters to the master database, save the table, export it to excel, and still have it be linked to the master database? So I would only have to update the one master excel sheet.

    Caveman425 pointsBadges:
  • Create Button to Open Specific Form

    I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am not...

    a2rose2l5 pointsBadges:
  • IF and then statement in query

    I'm having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don't know VBA

    tphester5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following