• Corruption in Access 2010 databases?

    Hello - is anybody seeing frequent corruption problems in Access 2010? I work with 2 other developers, and we are seeing: tables losing indexes losing ALL the code modules (form & global) in accdb losing the accdb itself (not in the Recycle Bin, not in our user drives; just gone) That third one...

    wilfridsoyer5 pointsBadges:
  • How to structure a Microsoft Access combobox with four columns, two columns from one table and the other two columns from another table

    Sir, I have two tables: Quartier and street. I want a combobox that displays Quartier ID, quartier name, street ID and street name.

    beltibrightGods4lif5 pointsBadges:
  • VB.NET with MS access data type dismatch

    provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" datafile = "D:\weighment\weighment.accdb" connstring = provider & datafile myConnection.ConnectionString = connstring myConnection.Open() Dim str As String str = "Insert into WeighingData...

    aishjack45710 pointsBadges:
  • Microsoft Access query: Pull records from later date

    I have 3 fields in a query. (A) is a date. (B) is a date calculated to be 2 business days after (A). (C) is another date. How do I make a query to pull all records where (C) is later than (B). I can't seem to figure it out because of the calculated field.

    jakebbb825 pointsBadges:
  • Network Connection Freezes

    For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

    DboiSOBE0 pointsBadges:
  • How to get a constant value at specified potion

    Select count(*) as  Ltotal from tblLeaveRequest where ApplyingDate Between '2016-03-01' and '2016-03-05' group by ApplyingDate.

    nadini40 pointsBadges:
  • Adding Serial Number to an already existing access document

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh

    Ansh12320 pointsBadges:
  • Microsoft Access subform modification problem

    I have a main form with 6 tabs. I added a 7th tab and inputed a subform. However, when I rearrange the subform in design view, the edits do not show in form view. It appears I can only make changes to the subform when a I use the "Subforn in new window" button. With all my other subforms I can make...

    fjn0bu15 pointsBadges:
  • Pass data from Access subform to another form

    In Access - How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form

    Bdbarnes5 pointsBadges:
  • Dbase III files exported from Access

    In Access you can export data to a dbase III, dbase IV or dbase V file. However when I do this for a dbase III file and try and open it is dbase III plus software it says it is not a dbase III plus file. How can I open the file in dbase III plus? I could append it as a CSV file but I was hoping the...

    cornisht20 pointsBadges:
  • Query pulling combo list box data

    I have a basic table in (column 1) list of individuals and in (column 2) lists the state(s) that the individuals hold licenses. Column 2 is a Combo Box Value List and several individuals hold multi state licenses. I am trying to figure how to pull out the states that require continuing education....

    emclean5 pointsBadges:
  • Fingerprint recognition in Java

    I want a programing source code for fingerprint recognition time and attendance payroll system in Java language. I also want the source code for capturing a fingerprint image and storing in MS Access in Java language for the same project.

    Anikketthakre5 pointsBadges:
  • Access Forms

    I am viewing my form in access that I have made in form view and the form is cut off half way down. It does scroll all the way down on the right, however the scroll on the left only goes halfway down. How do I get it to stop doing this?

    bubbie965 pointsBadges:
  • MS Access DATABASE and combobox in VB6.0

    hellooo plz i need help  i am new to VB6.0 and i've learned alot now i have a database in MS Access and i want to create a combobox named (Combo1) that will be populated from the field (Name) in table (Customer) in the database (weighbridge.mdb) and then when i choose a name in the combobox i want...

    Ahedfares895 pointsBadges:
  • Linked tables corrupted Access 2007

    I have been using an Access database for some years now, it comprises of a front end called sitecal.mdb and has a back end which I think are all linked tables called sitedata.mdb Last week the sitedata.mdb which contains the linked tables crashed and I now get the error: Unrecognized database...

    domingoo5 pointsBadges:
  • .MAR File opening with Microsoft Access

    How can I open a MS access report shortcut file using MS Access?

    NehaSoni5 pointsBadges:
  • Many to one relationship in Microsoft Access query

    I have the following tables: ISSUEREASONS(issueID, issueReason = "PNR Change"), Issues(issueID, partNumber), Parts(PartNumber, DDSID), PNR(PNR, DDSID, PNRChangeReason="PNR Change") where there is mostly all one to one relationships besides there is multiple PNR to DDSID. I need to query for both...

    tabooka15 pointsBadges:
  • Microsoft Access: How to create an entry form for a team event with up to 4 members on each entry form

    I am trying to create an entry form (order form) for a golf event. (There are 5 events per year.) Each event is a team event, involving 4 entrants (members.) So I want the entry form to have the event name once, but each of the four members' names on the entry form. I am having great difficulty...

    janeyr5 pointsBadges:
  • Microsoft Access 2016 MSO – How to save data to Table A

    I don't know if the table has to be attached to the form to copy to the table and do I have to click save or does each record save when I reach the end of the row

    dannyboy14145 pointsBadges:
  • How to save query in Visual Basic

    There's one other thing that might cause a problem. Microsoft Access, if that's what you're using, doesn't support COUNT DISTINCT. (At least, it didn't in Access 97. I don't have Access 2000 or 2003, so I can't test it.) To get around this, just use a saved query, which is the equivalent of a view...

    Habibg7975 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.

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

Following