Search results

  1. R

    Pivot Chart - data fields automation

    Hello. Im playing around with the pivot chart to make it dynamic. (VBA) Ive been searching the web, both here and there to find what im looking for, but without no luck. So. My case... I manage to create, open and edit a pivot chart... So imagine that this basic code is okey. My problem...
  2. R

    Printing into an access database, line printer, emulation

    Hello!!! Have some old plc (Programmable Logic Controllers) at home... i want these to print records into an access database on the network, (A PC in the same house). I have a software that have this feature, but it isnt open source, so i cant find out how they did it.. in the PLCs you can...
  3. R

    Tricky! Event log - show eventID and the next 5 minutes

    Hello. Im working on a db that analyze a event log. What i need is a query that output a certain eventID and the following 5 minutes of events. for instance: this sample list is the input. the eventID that im looking for is "Alarm 1" eventID date time Alarm 1 12.01.2008...
  4. R

    how to copy records/Recordset.

    I have created a db of events. these events shall happen every year. so i need to copy the events from last year in to this year, and next year copy this year, using vba. for instance say: i have two records, bowling night and juggling night. hehe funny life.. anyway. each of these events...
  5. R

    link from ms outlook to access

    Hello. im doing a event project here. first, i have created a access db. this db is connected to a sharepoint site. which again is connected to a shared calendar in outlook. the data displayed in this outlook calendar is the same fields as in the access db. so i wonder if it somehow was...
  6. R

    generating fieldname from string.

    Hell experts. i wondering how i can generate a fieldname from a string. for instance, in my table i have a field named "Field 26" i want to create the [field 26] from a string with a user input nr. (UserInput as Integer) all i need to know is how the syntax must be.. something like this...
  7. R

    deleting all related sub records when deleting the "main" record.

    I have two tables. 1. Persons (list of persons) 2. Job history (list of jobs) each person have their own job history. all these jobs are stored in the job history table. when i delete a person i would like the job history for this person deleted as well. each job stored in the job table have a...
  8. R

    wirte value in another table based on form input

    i have two tables. table 1 table 2 i have created a form for table 1. in this form i have a dropdown list of the records in table 2. so i wonder how i can flag one of the records in table 2 as selected when i choose this record in the dropdown list. my idea is to use an field in table 2...
  9. R

    development plan db

    I doing a db that is supposed to show the development plan of some persons. 2 tables: graduates departments in the graduates table there are among other data about the graduates, four fields for their departments in the next year. i have called them: rotation 1 rotation 2 rotation 3 rotation...
Back
Top Bottom