Recent content by Roy riggsjø

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

Its some old ABB 400 plc's.

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

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

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

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

hehe, i know its a bit strange. but im working on a project trying to reduce loops in the code. what i need is actually if the user type in 26. then field 26 should be set to true. it is 52 fields.... for 52 weeks....

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

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

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

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