Search results

Hi Moto, I've looked at your DB, as Alanisdman said, you need to normalise the tables Check the attachment for a quick idea.

Hi, Just a quick question. Do you need to store the month end figures in a table or just run a query each month to get the total?

Hi, I've looked at the tables and have a few suggestions: The Employee table looks fine, but some of the others are a little off. Taking the Positions table. You would only need about 3 fields: PositionID, Position, EmployeeID You can then link the employee# and employeeID fields. A similar...

Hi, I think an SQL statement will be what you're looking for. Try CurrentDB.Execute ("UPDATE [GL_LINES] SET [GL_LINE_FLAG] = 1 WHERE [LINE_ID] = " & Forms!frm_LINES_ALL.LINE_ID.Value & ";") If Forms!frm_LINES_ALL is the current form, then replace this with me Doing it this way you do not...

Hi, If it's only ID's you need to store then set the First name, surname fields as they are, then set the rest as Lookup fields.

Hi, I'm not overly sure what it is you're trying to do. But a Query does not store data. The query simply looks up the information from a table. To be able to see the info in the query it would have to be saved to the table?

Hi, You can go to the settings menu and do it from there. Not too sure if you can do it with code.

Thanks Banana, Interesting read, more than likely I'll be using this at some point soon.

Found an easier way. 1) Get a list of fonts off of Wikipedia 2) Put them as values in the ComboBox Also on the color side, I went for 3 x sliders to adjust the R,G,B values Simples!

Seemed so simple in my head! Also looked at creating a color selector form, but again I think a simple list of pre-defined 'Themes' is the easier option! Although I'm sure VB has a color selector form built in. Anything like that for VBA?

Thanks for that, seems a little OTT for what I'm thinking. Maybe I'll just use a Value list of "Aerial";"Verdana";........ instead! Thanks for the reply though! You would have thought that a simple: For each font in system.fonts next would be easier!

Without data it's impossible to give a solution, but I would assume that the serial field would be a unique field so with a create table query you could make a new table with all the products in it. Again, only a theoretical solution as I have no insight to the current format of your DB.

Just a couple of ideas for you Dealer If you use specific dealers then you could add a dealers table. This could be a linked ID to the dealers table. Product Again if you buy specific products, or have an itemised list of company products this could also be linked. RespPerson Would link...

Theoretically yes the code should repeat itself the number of times in the textbox, but i'm not too familiar with the commands. an INSERT INTO command is really what you are looking for. Still not too sure why you want to duplicate records though. The idea of databases is to reduce the...

Hi, I can't see the Quotemultitbl being relevant to the code. Is this another table in your project?

Easiest way around this is to do an INSERT statement: If you send me a sample of your table I'll have a look at it and talk you through what you need to do.

I think you'll need to do this in VBA as I'm not sure how to for...next in a macro. There should be an option to convert Macro's to VBA. What version of Access are you running?

Hi, I'm looking to add a user settings functionality to my DB and wanted the user to be able to select which font, backcolor, forecolor Logo .... they want to see on there individual workstations. What I need is to be able to create a combobox with a list of all the fontnames. Searched...

On your form, create a text box called txt_count On the OnClick event for the button you need to create a for...next loop. For i = 1 to me.txt_Count (YOUR CODE TO CREATE DUPLICATES GOES HERE) Next i

Hi, Yes, adding a textbox next to the button where you can input the amount of times to duplicate it will work. I am curious though, why do you want duplicated records?