Search results

Hello, I need to know how can I make an unbound field on a form that will have a value of: eg: 500 and the next time I will open it, it will be 501 the time after, 502 and so on and so forth. This form isn't based on a table, so I cannot do it with autonumber, I need to be able to do that on a...

Hello, I need desperate help. I've designed a form, (which is a receipt) and I would like to have the ability to take the form as it is, and copy it to a file. I don't mind if it's Word, HTML or Excel. Problem is, that when I'm using the Macro: OutputTo, it shows me a very weird looking table...

Hello, I would like to open a form, only if another form is opened. Can I do this in a macro? Is there like a condition to that? Thanks in advance, Tal.

Hello, I have a form in which I've got a combobox that has 2 values: "Done" or "Not Done yet" Now, when I have a few values of "Done", I'd like to be able to refresh the form and have only the "Not Done Yet" to remain. F5 does it, by refreshing the entire form, but the "Refresh Form Data"...

Hello everyone. I'd like to have a combobox that contains values such as: value 1 value 2 and when I choose a value, it should run a query. Can someone please tell me how to do that, without VB? I'm new to this, and I would appreciate assistance. Please tell me exactly what to do. Thank...

Hello, I've got 2 different queries, each calculating a total. Now, I'd like to do sum the 2 Total fields of these 2 different queries. That means: Query1Total+Query2Total=OverallTotal I created a new queey to sum this up, but it doesn't work. When I run the query I keep getting: "Enter...

Hello, Is there a way to show Outlook's calender in Access 2007? I really need to know how I can do it, if it's possible. This way, I can manage Outlook through the DB. Any ideas guys? Thanks in advance, Tal.

Hello everyone. In my database, I've got a journal table, in which I have a field: Hour Thing is, I would like my customer to be able to type hours AND I will be able to make a query that will pop up a msb box IF the current time is earlier then the Hour field. Problem is, when I put "Date/Time"...

Hello, I was wondering how can I make a Combo box, in which I will type, for example: Financial report and by selecting it, I will get that specific report opening. Same goes for more values, and reports that matches. There's an example of exactly what I want in Marketing Projects in Access...

Hello everyone. I'd like to know how can I do the following: When a user opens the DB, There's the autoexec macro that opens the form on which he's supposed to be working on. (by his demand). Problem is, that on the left side of the screen, there's the "tables, forms, macros, queries" etc...

Hello everyone! I'm new to Access programming, and have a question that would help me a lot. I've created a DB in Access 2007, which works just fine. I've saved the DB as MDB to be 2003 compatible, and sent it to my friend, who needs it. He is using Access 2003, but he can't work with the DB...