질문하기

CEAuke's profile - activity

2017-03-21 22:31:38 +0200 받은 배지  훌륭한 질문 (source)
2016-02-29 04:40:43 +0200 받은 배지  정리의 달인
2015-09-06 11:12:00 +0200 받은 배지  유명한 질문 (source)
2015-06-21 20:47:01 +0200 받은 배지  유명한 질문 (source)
2015-04-15 20:54:39 +0200 받은 배지  주목할 만한 질문 (source)
2015-04-15 20:54:39 +0200 받은 배지  유명한 질문 (source)
2015-03-14 11:27:00 +0200 받은 배지  유명한 질문 (source)
2014-08-19 18:51:13 +0200 받은 배지  유명한 질문 (source)
2014-08-18 18:39:35 +0200 받은 배지  유명한 질문 (source)
2014-07-04 09:42:11 +0200 받은 배지  유명한 질문 (source)
2014-06-26 23:28:36 +0200 받은 배지  주목할 만한 질문 (source)
2014-06-26 23:28:36 +0200 받은 배지  인기있는 질문 (source)
2014-06-25 10:24:31 +0200 받은 배지  주목할 만한 질문 (source)
2014-06-25 10:24:31 +0200 받은 배지  유명한 질문 (source)
2014-06-18 16:46:33 +0200 받은 배지  인기있는 질문 (source)
2014-06-18 11:46:48 +0200 질문에 댓글을 달았습니다 In Base, how do you insert a form field on top of an image?

This is working for me when I go: Insert -> Image -> From file. By default the controls (e.g. text box) is on the top and visible when I run the form.

Which bit wont it let you do? I found that if the image is on top of the text box, then I cannot select the text box. But if I send to back, then the text box is selectable in the design view.

2014-06-18 00:53:49 +0200 질문하였습니다 What is the fastest way to open the LibreOffice Basic window?

Are there any shortcuts for opening the LibreOffice Basic window? Currently it takes me 8 clicks to get to any code. In MS Excel I click on the developer tab and then visual basic and I'm in. Is there something similar in LO? Or at least something faster than my 8 clicks?

2014-06-16 16:19:10 +0200 질문하였습니다 Tips for displaying or entering calendar based data?

Hi guys

I would like to collect and report on calendar based data. E.g. data with limited attributes but where I want to display it in a nice calendar.

e.g. I have a database table called timesheet. The date field is unique and I have columns for location and hours.

How can I display this information in a report/form in a nice calendar layout with ideally the option to modify the location and hours values.

Basically I need a multi-record display but in a form layout (as opposed to a table layout). If that is possible I can probably write a marcro to move the fields in the right place.

2014-06-16 16:11:49 +0200 코멘트달린 답변 How to access an independent form in access2base

Hi JPL. Thanks for all your support. This comes back to a question that you answered before. A2B of yours doesn't current support more than one main form in writer when you have the one form in base. But it causes me no issue to have a master form in write and then use subforms in write. I dont know why I couldn't get it to work before. But now I have: PAYMENTS in base and writer and then UNASSIGNED_INVOICES is a subform as opposed to be an independent form in writer. That works fine :)

2014-06-16 16:09:32 +0200 받은 배지  인기있는 질문 (source)
2014-06-16 14:57:31 +0200 받은 배지  주목할 만한 질문 (source)
2014-06-16 09:00:17 +0200 받은 배지  유명한 질문 (source)
2014-06-16 08:58:20 +0200 받은 배지  인기있는 질문 (source)
2014-06-15 22:35:05 +0200 질문하였습니다 How to access an independent form in access2base

Hi guys

I have a form in my odb file called PAYMENTS. That has a subform called ASSIGNED_INVOICES. There's also a third form which is independend from payments (NOT a subform) called UNASSIGNED_INVOICES.

How can I access UNASSIGNED_INVOICES programatically?

I cannot find it in the controls of the PAYMENTS form. I cannot find it in the allforms collection.

2014-06-15 21:13:23 +0200 질문에 댓글을 달았습니다 What are the differences between forms in Base and forms in Writer?

My final note on this: (source http://www.access2base.com/access2bas... ) allforms will return all forms of the db forms will return all OPEN forms.

A subform is firstly a control of the parent form. So if FRM2 is a subform of FRM1. Then to access the controls of FRM2, you have to: allforms("FRM1").controls("FRM2").form.controls So even though FRM2 is firstly a control, you have to get the .form of it to access it's controls

2014-06-15 20:32:43 +0200 질문에 댓글을 달았습니다 What are the differences between forms in Base and forms in Writer?

Ok, I just noticed that the Error #1507 happens when the writer main form and and base form are not named the same. So I guess they are more or less the same object. The error message wasnt that clear but I guess it's trying to say it: "Form formname not identified in database Form set"

2014-06-15 18:43:13 +0200 질문하였습니다 What are the differences between forms in Base and forms in Writer?

Hi guys

Can someone please clarify the functional and technical names/differences for the forms that you have in base and the forms and subforms you have in writer.

I'm writing macros for a base frontend form but I realised that if I have a subform in the form in writer I end up with at least three different names/forms. From what I can tell only the base forms are in the forms collection. But why are they all called forms if they appear to refer to different functional uses?

  1. In base I have a form with a name
  2. In writer, if I go in design mode I can modify form properties. This form has a different name from the base form. But as far as I understand it's still called a form
  3. Additional sub forms have the same properties as number 2.

Are these forms all the same objects? If so, why is form 1 and form 2 not the same?

2014-06-13 14:59:17 +0200 받은 배지  편집자 (source)
2014-06-13 01:05:20 +0200 받은 배지  주목할 만한 질문 (source)
2014-06-12 16:04:01 +0200 받은 배지  논객
2014-06-12 16:04:01 +0200 코멘트달린 답변 BASE: Subform with flexible relationship to form

Thanks. Your idea worked. Two subforms did the trick as I explained the longer answer section that I replied to earlier.

2014-06-12 15:20:53 +0200 질문에 답변하였습니다 BASE: Subform with flexible relationship to form

Hi Frofa

Thanks for the thorough reply! I think I see what you're saying. This is almost like a field chooser form. You have two lists (A+B, in subforms) when you select a row in list A and press the button to add, it removes from the A subform and adds it to the B subform. And vice versa.

So subform A (unassigned invoices) will be a SQL query with a where condition where payment_id is null. Subform B (the chosen invoices) will have a a table query joined to the payment. I just have to figure out what to put in the macro. Something like update current subform A record to add the payment ID and refresh subform A. I'll give it a shot and let you know how I get by.

2014-06-12 15:20:26 +0200 코멘트달린 답변 BASE: Subform with flexible relationship to form

Hi. The comment section wont allow a long enough reply, so I'm writing an answer in response of your proposal

2014-06-12 00:46:11 +0200 받은 배지  인기있는 질문 (source)
2014-06-11 12:02:34 +0200 질문하였습니다 BASE: Subform with flexible relationship to form

Hi guys

I have a form and subform where the subform's data is created BEFORE the main form. I guess in the normal flow, the parent record is created first and then the children. E.g. invoice header first and then invoice lines.

However, I want to build a form where you select which invoices you want to pay. So I'm thinking that the parent form should be payments and in the child form it should show all the invoices that's unpaid. Once you select the invoices and the payment is created, the form should in future only show you the invoices paid by that payment.

so my invoice table will have a payment_id field. In the beginning the subform should show where payment_id is null. Once payment status=saved/paid or something the logic of the subform should change to show where payment_id = main form payment ID.

I dont know how to modify my subform to implement this. Should I base it on SQL query? How do I pull in the value of the main form into the SQL statement to get the payment_id?

Is my model wrong? Maybe I can start with a form with only listing the invoices and checkboxes against them and when you check some and press a button, a macro will create a payment record and update all the ticket invoices. But how do I page through selected records in a macro?

2014-05-27 01:03:11 +0200 받은 배지  주목할 만한 질문 (source)
2014-05-26 05:33:36 +0200 받은 배지  인기있는 질문 (source)
2014-05-24 19:46:57 +0200 질문하였습니다 BASE: how to stop auto next record

Hi guys

How can I stop base/forms from going to the next record when I tab from the last field in the tab list?

Can you interrupt the events? Or should I write a macro to jump to tab1 after exiting the final field.

I checked on the form but there's no option for autoadvance. On the form event side, I dont know how to write a macro for BEFORE-event to stop that event from executing.