Search results

What I have is a form where you put data in "Report Type", "From Date", & "To Date" and click submit. This in turn runs an append query depending on the report type selected and opens the report in the Print Preview mode. Now the problem I am having is that the data is showing up correctly on...

My suggestion is to always have the Data in a "backend" that way if something goes wrong with the front end you can still access the data. Also doing this allows you to put a front end on each users local computer that connects to a central location where the data resides. What I also do is...

My solution to this problem was to create an "Update Database" that has the "BE Version table in it (the BE version would be the updated version) and link that to the Database where the FE resides.

That's what I was afraid of :( I was hoping that since I could do it with the date format function that maybe I could do it with the color too. Salavie'. Thanks.

I am trying to figure out how I can change the color of only a certain section of a report using code. See example: =("We are pleased to inform you that your request for " & [Provider Name] & " to join " & [Group Number] & " – " & [Group Name] & " has been completed effective " &...

Thanks that is exactly what I needed to do! :) It works perfectly now.

Only problem is that I have a query run on form load and a Sum function in the control of the text box. it isn't linked to a table.

No such luck.. still doing the same thing. I was hoping this would have been something easy to do. In theory what code would you use to change the text color to a different color depending on if the number was a positive or negative number?

Where would I work that into my code?

Grr.. Still no luck. I created an uncontrolled text box formated as Currency on the main menu that gets the dollar amount from a query that is run when the main menu loads. Changing the color seems to work as long as I don't want to change the color to a different color using a variable. I am...

It gave no errors at all. Just left the original color I had set the text box to be. (with quotes) without quotes it changed the color to the first color I had listed in the code and ignored the rest of the code.

I tried it without the quotes and it didn't work at all. It is a financial database. A query is used to populate this field so that when the main menu is opened it shows the current bank balance. I am not an expert at AcessDB.. Conditional Formatting?

I have dollar amounts in my database and I need it to do something like this If amount = $0.00 text should be Black If amount is Greater than $0.00 text should be Blue If amount is Less than $0.00 text should be Red Here is what I have tried, but only keeps the 1st coded color. I have this...

I need to have a field on my form so that when a person saves the record a confirmation number is generated. Example: "0000-00-000" I need it to be a random number though not incrimental. Is there some code I can use on an Event procedure that will accomplish this?

I have a financial database and what I am trying to do is to have the main menu update the "current balance" field when a new transaction is saved in the "check register entry" form. here is what I am using, but it doesn't update the main menu. What am I doing wrong? Private Sub Save_Click() On...

when you got to 2006 you could just change the 5 to a 6 I am not sure how to make it change automatically.

Try creating a query that pulls all this data from the table where patient information is stored and then have the report get it's information from the query.

Go into the design view of the table and right click on the field you want to be your primary key and click the "primary key" icon. then go to this field and modify the "format" properties to something like "5-0000" that should make 5 the constant and the 0000 should change incrimentally.

Screen Print example attached I do have it saved as a popup type; which makes it a shorcut menu bar. I will try setting the shortcut menu property on the form and see if that works. * I think the problem is I have it set so the database window hides; and the form pops up looking like an...

I have my database set with pop-up forms, but I need to allow users the ability to right click on forms and view options I have set in a custom menu bar. For some reason I can't get right-clicking to work on these types of forms. Does anyone have any idea how I can accomplish this or if there...