Search results

Is there a way to find out how much space is left between the Report and the Page Footer of a report? I want to move a sub-report place in the report footer the the bottom of the page, just before the page footer and I think I could use that with the .Move method. By the way if anyone out...

I have a form which, among other controls, has a multi-line text box, TB_Conditions. I generate a report based on the data of that form and in that report I have a sub-report, rptConditions, that displays the data of TB_Conditions which is placed in the Page Footer of the main report. In the...

I have a subform displayed in Datasheet form and I would like to store in a field negative integers. But, for UI and usability purposes, I don't want the user to have to write the "-" for the negative value to be stored. is it possible that the user will write the number i.e. 1 and in the table...

I have a subform inside a form and in this subform I have an Ordering field which orders the items in the form based on this field. In the After Update event of this box I use Me.Requery so that you can actually see the change of the order in the items. The problem is that after requering the...

I have a form bound to a table, with a subform in there, and I have a textbox with a source one of the table's fields. I would like the value of this textbox to be calculated based on the values of some boxes in the subform, but I also wont to be able to edit the value on the textbox myself. Is...

Hi everyone, I have a form, and in that forn a subform with a list of products. This is the Recordsource of the subform: SELECT DISTINCT ProductSubCategory.ProductCategoryID, Product.ProductSubCategoryID AS SubID, Product.ProductID, Product.ProductCode, Product.Description, Product.VATRate...

Hello everyone, I have a table "Product" and in this table I have two fields "StoragePlaceID1" and "StoragePlaceID2". Both these fields link to the look-up table "StoragePlace" *Attached Image "Product_StoragePlace" from the Access Relationship Window"* When I want to add a new Product from my...

Hello everyone, I have two tables "Products" and "Sales". I have a Main form with a sub-form in it that displays all of my Products in the "Products" table which is in datasheet form. I want to create another form for my "Sales" table in which I will add items from the "Products" table. I want...

Hello all, I have a 2D array, 1st column holds dates and the 2nd one holds ones and zeros. The 1st column is the duration of the stay of someone in a hotel and the 2nd column determines if at the given date that person's room need to be cleaned(1) or not(0). Now, if the day that the room is...

Hi guys, I'm trying to open a recordset in vba and I'm getting the 3061 runtime error,Expected 1. After some searching I found out that the problem is that I'm trying to open a recordset with a query that uses a referance to a form control. Could someone please explain to me how I should go...

Hello guys, I have a problem with a query I wanna write. I have a field in a table(text field) which is like this Field ==== ABC-1 ABC-15 ABC-6 note: it's just 1 column. What'd I'd like to do is check the number after the "-" and if it's 1digit change it to the same but with a Zeoro (0) in...

Helo everyone, I have a bit a performance issue with a loop I'm using to create a report. let me elaborate a bit :) I've create a db that uses linked tables to an SQL db,which is used by an ERP program for hotel management, that a client of us uses. Because that ERP program has some problems...

Hello everyone, I want to create a report for the Monthly cleaning plan of a hotel. For each day, how many rooms need new sheets, how many need new towels etc. At this point I can generate a report for any given day. This could be an example of what I want to achieve ------------ Date |...

Hello everyone, it's been a while since my last post here :) I have problem that I need your help with please. I have a database with information about Hotel Rooms (reservation dates etc). I have created a form that lets you select which days you want a room to be cleaned when it is reserved...

I was just wondering how difficult it would be to transfer the form I've created in Access-vba- to a Windows Form Application in Visual Studio. I've created a form for a database that we have in our company that calculates for you the cost for a chosen route. It'll be used by our tech support...

Hello guys, I have a database of this form: tblDestination(id,Destination) tblDistance(Destination_id,Distace_From_Home) Destination_id is a FK that references the id of the "tblDestination". I have created an unbound form, for this db, called "frmStops" and in this form I have a combo box...

Hi guys, I have a DB that I store the ranking of several sites around the world using data I've gathered from Alexa (http://www.alexa.com) I have 3 tables in my DB Country(ID, Name) Rank(Country_ID,Site_ID,Rank,Rank_Timestamp) Site(ID,Name) I want to export data about the rank to create some...

Hello everyone, I've tried searching about my poblem but I can't find somethig about it (pretty sure it has to do with the words I'm using to search but anyway...) I have a table Names: (id, Name, Nick_Name) I have a form with 2 comboxes both based on that table. 1st combobox lets you browse...

Hello everyone, great forum, I've got soooo much help from all of you guys!! Thank you very much :D:D I have a Database with Geogafical Regions, Municipalities, Cities etc. Because it's difficult to explain how my DB works using my tables( it has to do with how the system of municipalities...

Hello everyone, I have a table in which I store date about cities. Among other fields, there are two fields Title_1, Title_2 and both refear to the City's name, Title_1 has the city's name and Title_2 has an abbrevation of that city's name. In Title_2 there are some records that are null cause...