Search results

I have a main form with several continuous subforms on it. These subforms are based on a selection of fields of a complete and editable form, so these subforms are overview forms so to speak. Whenever a field of a certain record is clicked, the other subforms show the linked data for that...

Well.... I can't ;) Structure of DB and relations is included in jpg. I have created two separate parts for sales. One which is used for over the counter sales, and one which is used for sales and labour per case. I've created two forms (a form with a subform) for the bottom ones. Whenever...

I have a subform (continuous) which shows a summary of all clients basic data in a list. Clicking a client requerys and refreshes some other subforms so the accompanying data for that client is shown. Whenever I double click a record, the "main" window for that "object" opens. So say I double...

I'm getting an error message (informational only): This happens when I start entering data in the field "productname" of a subform. So I'm assuming something in the form or in the code of the form is referring to ClientID. but I've checked it, and there is nothing referring to it anymore...

Please see the attached two files. I have tried to figure out what the difference in functionality would be between 1 and 2. In the latter I have just created a series of relations between the last two tables (but that structure could be used throughout the whole DB instead of hanging it...

In this thread: http://www.access-programmers.co.uk/forums/showthread.php?p=549287#post549287 I had a problem. Now I decided to just make two tables, one with sales for a "passer by" and/or directly to a client without a case/labour costs. And a table for sales in relation to a case with labour...

I don't really know of all info below is needed to help me answer my question, but I guess it won't hurt to have you guys know how the structure is up to now. I have a DB with the following structure/tables / numbering / relations. Attached to this post a small jpg where you can see the...

I have a form, on the form a textbox. Through the expression builder I have assigned one value to the control source of that textbox from a query. The query holds three values, all three of which I would like to use in a separate textbox. When I open the form the textbox just displays #Name. I'm...

I know I have read a topic which handles this... there was a piece of code in it too which makes access round numbers correctly up or down to the second decimal based on the third. Access seems to do this a bit strange so small differences occur when calculating with currency for example. But I...

I've only recently gotten to know about continuous forms and their use a bit. So for example, I used a maximum number of pre-defined (6) visits. I need to change that still, but during the development of the sales forms I already ran into a problem. At first I was planning to have a certain...

Hi, I have a query for a subform which is displayed in datasheet mode (see attachment). I've created a form based on a query and used it as a subform. The "casenumbers" per clients are displayed from 1 and upwards, I would like to have them sorted Descending. So in the query I sorted them that...

Don't know if everyone is up to speed about this, and asuming some of us use a laptop everyday.... I guess it's been in the news (since a hold of an airplane is supposed to have catched on fire, quite extreme), but still... Sony tried to do something to increase battery capacity and by now...

Suppose you have 10 fields on a certain spot in a form. And you want to place these ten controls, say command buttons) to line up under each other with an even spacing of about 0.2... Up to now, for a whole lot of controls, I've been selecting them one by one (or "line" by "line"), and manually...

How to go about this? I have a couple of fields: Starttime and Endtime -> difference is stored in TimeLength That part I could figure out on my own and seems to work nice. But this I can't: I have a combobox with a couple of values in it called Tariff (data type: Number, Field size: Double...

Hello all! Maybe strange, but I have litterely created a new database from my "old" one. I did this because I thought the size of the database was growing way to fast. What I did was open two instances of Access, one with a new empty database open and one with the other "old" database open...

Add a file/add an attachment to a record and be able to open it from within your form Ok... this post went from a question to an answer: So for all the people who should struggle with this problem, take some time (just 5 minutes) and try it. It should work like a charm. After fiddling around...

Hi, I have an old form (see oldform pics) and a new form (see newform pics). The old form has controls on it which work just dandy (well, at least they display and store information). The new, tabbed, form however does not. What's up with that? I simply created a form, created a tab control...

I'm trying to make 1 table from 2. Copied the fields from one to the other tried to save... No luck. Error: Property value is too large. The help accompanying the messagebox is: So I click ok. Then another message pops up: Errors were encountered during the save operation. Properties were not...

Hello again, I have three questions this time 'round: 1. I'm in need of some way of preventing a user from opening form B unless he has entered information in form A. Right now it is possible to open form B without entering data in form A (form A being the date/time info and form B being...

Well, I couldn't find this using the search, so here it goes: I have a form in which I enter data to create a new client. Within that form I have a subform in datasheetview which is based on a query which holds/retrieves certain (important) fields from a table that holds case info. So in that...